I guess I had the LIMIT in the wrong location. Thanks for the help!
Mike "Mike Wexler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Mike wrote: >> I have a SELECT statement for MS SQL that is >> >> SELECT TOP 1 id FROM menu_links ORDER BY id desc >> >> and need to convert it to MySQL. I cannot find what will do that. >> >> Help is greatly appreciated. >> >> TIA >> >> Mike >> >> >> > SELECT id FROM menu_links ORDER BY id desc LIMIT 1 > >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
