ANY answer.
Re: how to find out the 4th highest value from the column?
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;[/sql]
|