List:General Discussion« Previous MessageNext Message »
From:Chris Sansom Date:September 15 2006 8:46am
Subject:Re: How to sort last n entries?
View as plain text  
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
Thread
How to sort last n entries?Dominik Klein15 Sep
  • Re: How to sort last n entries?Chris Sansom15 Sep
    • Re: How to sort last n entries?Dominik Klein15 Sep
  • Re: How to sort last n entries?Martijn Tonies15 Sep
  • RE: How to sort last n entries?Peter Lauri15 Sep
RE: How to sort last n entries?Peter Lauri15 Sep
Re: How to sort last n entries?Dominik Klein15 Sep
  • RE: How to sort last n entries?Peter Lauri15 Sep
  • RE: How to sort last n entries?Peter Lauri15 Sep
Re: How to sort last n entries?Brent Baisley15 Sep