Re: How to sort last n entries?

[Chris Sansom]

At 10:41 +0200 15/9/06, Dominik Klein wrote:
>I have a table with primary key "id". Another field is "date". Now I 
>want the last n entries, sorted by "date".
>
>Is this possible in one SQL statement?

ORDER BY `date` DESC LIMIT n

-- 
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/

A censor is a man who knows more than he thinks you ought to.
    -- Laurence J. Peter