This might work, I've used this syntax to select and sort from a UNION.
SELECT * FROM (SELECT * FROM table ORDER BY id DESC LIMIT n) AS ltable ORDER BY
datefield DESC
According to the documentation you can use limit in subqueries:
A subquery can contain any of the keywords or clauses that an ordinary SELECT
can contain: DISTINCT, GROUP BY, ORDER BY, LIMIT,...
----- Original Message -----
From: "Dominik Klein" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Friday, September 15, 2006 5:44 AM
Subject: Re: How to sort last n entries?
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]