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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]