Re: Select Last X rows

Ah that makes sense. It's a double shot, first grabbing the necessary records, then selecting all in that temp value (hitlist) in reverse order.

Well done.

Cheers

On Jun 30, 2007, at 11:26 AM, Octavian Rasnita wrote:

> Hi,
>
> Try something like this:
>
> select * from (select * from table_name where ... order by
> last_update desc limit 10) as tbl order by tbl.last_update;

Rich in Toronto

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com