View Single Post
  #3 (permalink)  
Old 12-05-2007, 03:46 AM
Unregistered
 
Posts: n/a
Lightbulb ANY answer. Re: how to find out the 4th highest value from the column?

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;[/sql]
Reply With Quote