SELECT max(id) FROM menu_links :)
> -----Original Message----- > From: Mike Wexler [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 29, 2006 1:22 PM > To: Mike > Cc: mysql@lists.mysql.com > Subject: Re: MS SQL TOP Replacement > > 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]
