Re: select largest

[jkraai]

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