Re: selecting the last and second last id's

[mos]

At 04:00 PM 5/28/2007, [EMAIL PROTECTED] wrote:
My primary id is an auto incrementing table and I want to return the 
highest and second highest id.

Any ideas?

You should of course have an index on Rcd_Id:

Select rcd_id from mytable order by rcd_id desc limit 2

mike 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]