How to find the n-th record ?

[Shuja Ali]

SELECT TOP 1 * FROM (SELECT TOP 2 * FROM TABLENAME ORDER BY COLUMNNAME DESC) A ORDER BY COLUMNNAME ASC 

This will show the second highest record. I am assuming that the Field COLUMNNAME is what you are actually refering as recordID.