From: jkraai
Date: March 29 1999 2:57am
Subject: Re: select largest
List-Archive: http://lists.mysql.com/mysql/1116
Message-Id: <36FEEC2C.7C76DCD9@polytopic.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

lorin@stripped wrote:
> 
> I have a database with a column defined as:
> NOT NULL AUTO_INCREMENT
> Is there a simple SELECT statement to grab the 5 largest entries?

select * 
from table
order by <auto_increment field> desc
limit 5