Query to select top nth record:

consider the table name as emp,then

select empid
from emp e1
where ( n =
( select count ( distinct ( e2.empid ) )
from emp e2
where e2.empid >=e1.empid))

replace n by 3 to get the third maximum