You can use ranking function
With empinfo
As
(
select empName,Salary,Row_Number() Over ( order by salary desc ) as RowID
from empinfotable
)
select * from empinfo where RowID=5
you can try this also
SELECT empname,salary FROM Employees ORDER BY salary DESC OFFSET 4 ROWS FETCH NEXT 1 ROWS ONLY;
which works in SQL server 2012 and above
check this link for more detail
OFFSET FETCH Clause