ANY answer.
Re: How to find second highest value of a column in a table?
you can use this and this is general you can find any highest value
[sql]select min(sal) from (select sal from emp where sal is not NULL order by sal desc) where rownum<=&rownum[/sql]
|