tags:

views:

41

answers:

2

how to find the maximum value in a column with integer values without using aggregate operator in mysql

+1  A: 

How about something like

SELECT <Value>
FROM <YourTable>
ORDER BY <Value> DESC
LIMIT 1
astander
A: 

You can do:

SELECT IntColumn FROM MyTable ORDER BY IntColumn DESC LIMIT 1
Scott Stafford