Re: How to sort last n entries?

[Dominik Klein]

Peter Lauri schrieb:
> SELECT * FROM table WHERE id=(SELECT id FROM table ORDER BY id DESC) ORDER
> BY date

This does not limit it to n entries (order by date limit n is not 
sufficient as I need last (highest) n ids). And afaik, limit is not 
allowed in sub-queries.