how to find out the 4th highest value from the column?

Dialect: SQL 92

Dialect: Oracle

SQL:

SELECT  ROWNUM AS RANK,D.SALARY

FROM (SELECT MAX(SALARY) AS SALARY

              FROM EMPLOYEES

              ORDER BY SALARY DESC) D

WHERE ROWNUM<=4

MINUS

SELECT  ROWNUM AS RANK,D.SALARY

FROM (SELECT MAX(SALARY) AS SALARY

              FROM EMPLOYEES

              ORDER BY SALARY DESC) D

WHERE ROWNUM<=3

You can do the same with

SQL:

select min(sal) from (select sal from emp where sal is not NULL order by sal desc) where rownum<=&rownum;

You can calculate the 2,3,4 or the whichever highest value of a column you want to retrive:

SQL:

select min(sal) from (select sal from emp where sal is not NULL order by sal desc) where rownum<=&rownum;