Re: MS SQL TOP Replacement

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 t

RE: MS SQL TOP Replacement

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 SELEC

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

MS SQL TOP Replacement

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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib