How to find the n-th record ?

[Shuja Ali]

If you are just going to look at the first record then why not do just this

SELECT TOP 1 * FROM table
WHERE .........
ORDER BY field DESC