Predicting SORT BY

[Brian Gordon]

I have a very large table that is always sorted by the primary key when I SELECT data from it. Actually, the very purpose of the data being in a database is so that it can be sorted like that. I was wondering, however, if there's some way to use the WHERE clause in SELECT (or a seperate token) to actually give me, say, the 10000th entry -if it were to be sorted-. Something along the lines of:
SELECT name FROM data WHERE %place% = 10000 SORT BY income DESC

So basically if I had a database of names and their incomes, I would need to find the name that has the 10000th highest income. Can anyone help me out?