The 4th highest salary from Emp table -Sql server
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 4 salary
FROM emp
ORDER BY salary DESC) a
ORDER BY salary
The nth highest salary from Emp table as follows
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM emp
ORDER BY salary DESC) a
ORDER BY salary
Other
=====
SELECT MIN (SALARY )
FROM EMP
WHERE SALARY IN
(SELECT DISTINCT TOP 4 SALARY
FROM EMP
ORDER BY SALARY DESC)