The last n records 2

[audiopro]

I need to get the last n records from a table in ASC order.
I know I can query the count and then limit another query to the last n.
I could also query the first n in DESC order and then flip them in an array.

Is it possible to get the last n records in ASC order with a single query?

Keith

http://www.studiosoft.co.uk

 

[jaxtell]

How about a subquery. This works for me

select * from (SELECT * FROM `locations` WHERE 1 order by zip desc limit 10) inTable order by zip asc

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[audiopro]

I don't uderstand the references to 'locations' and 'inTable', are they both the source table?

Keith

http://www.studiosoft.co.uk

 

[r937]

locations is the name of your table

inTable is the table alias of the derived tale produced by the subquery

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[audiopro]

Thanks - Problem solved

Keith

http://www.studiosoft.co.uk