This is probably easy, but I just can't to put my finger on it. I have a list of numbers (i.e. 1 to 175) and I want to do a select statement to get the highest number. I have tried the limit thing but not getting the right output. Can someone shed some light on this?
TIA
select * from table order by numcol desc limit 1
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
