Re: 5 last records ?

[Steve Ruby]

FL wrote:
> 
> Hi,
> 
> How to build an efficient query to display the 5 last records (order by
> date) ?


You can only display the "last" 5 ordered by date ASCENDING if you know
the total number of rows, otherwise you can cheat by sorting DESCENDING
and viewing the first 5..

select * from <tablename> order by <datecolumn> desc limit 5;