Programming Forums - View Single Post

Infinite Recursion · Jun 28th, 2007, 3:01 PM

If it has some sort of sequential id or date associated with the record, you could do this:

SELECT * FROM mytable ORDER BY seq_id DESC LIMIT 10;

Basically, this puts the last entries on top (via sorting in descending order), then limiting the results to 10 via LIMIT.

Jun 28th, 2007, 3:01 PM	#2
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	If it has some sort of sequential id or date associated with the record, you could do this: SELECT * FROM mytable ORDER BY seq_id DESC LIMIT 10; Basically, this puts the last entries on top (via sorting in descending order), then limiting the results to 10 via LIMIT. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."