List:General Discussion« Previous MessageNext Message »
From:Dominik Klein Date:September 15 2006 9:44am
Subject:Re: How to sort last n entries?
View as plain text  
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.
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