10 latest

[MrLister]

I have a row called essays_id and there's 25 ids. and i'm trying to get the last 10 so that would be from 15-25. if there were 36 it would be 26-36. what kind of query do i set up to do this? so it shows the last 10 essays_title submitted.

[freakysid]

Something like so:

SELECT *
FROM tableName
ORDER BY essays_id DESC
LIMIT 10