Re: MS SQL TOP Replacement

[Mike Wexler]

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]