find max value without aggregate operator in mysql

how to find the maximum value in a column with integer values without using开发者_Python百科 aggregate operator in mysql

How about something like

SELECT <Value>
FROM <YourTable>
ORDER BY <Value> DESC
LIMIT 1

You can do:

SELECT IntColumn FROM MyTable ORDER BY IntColumn DESC LIMIT 1