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?
Use ORDER BY to put them in the order you want, and LIMIT 1 to select the first row.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
