kranthi

• Dec 1st, 2005

 

select * from (select * from emp order by sal desc) where rownum <= 5;

pktelango

 Profile Answers by pktelango 

• Jan 19th, 2006

 

5th MAX Salary

select max(SALARY) from EMP A where 5=( select count(distinct(SALARY)) From EMP  B where B.ID>=A.ID)

Praveen Kumar M

• Apr 11th, 2006

 

SELECT    empid
             ,empname
             ,salary
             ,RANK() OVER (ORDER BY salary DESC) AS Rank_Salary
FROM emp
QUALIFY Rank_Salary<= 3;

nirav

• Jul 21st, 2006

 

select min(sal) from (select sal from emp order by sal desc) where rownum <=n;

where n is the nth highest salary you want.