Thread: i want to get the third highest salary from a table?
View Single Post
  #8 (permalink)  
Old 12-05-2007, 11:23 AM
deepak garg deepak garg is offline
Junior Member
  
Join Date: Dec 2007
Posts: 6
deepak garg is on a distinguished road
Wink ANY answer. Re: i want to get the third highest salary from a table?
use for any highest salary from the table

[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