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]