Top 10 salaries

[Suneelhema]

hi I want to know about a Query regarding Top 10 salaries from Emp and I want 1 to 10 numbers at the Regarding salaries


I want Out put like 10000 1
7500 2
5500 3
3500 4

[debasisdas]

try to use this

SELECT EMPNO,ENAME,SAL,DENSE_RANK() OVER (ORDER BY SAL DESC) AS RK FROM EMP ORDER BY SAL DESC
 

[subashsavji]

 
 
select rownum as rank ,ename,sal 
from (select ename,sal from emp order by sal desc) 
where rownum<=&n
//
 
SELECT min(sal)
FROM (SELECT sal
FROM emp 
order by sal desc)
WHERE rownum<(&nth_heighest+1);
//
 
select ename, sal
from (select ename,sal,dense_rank() over(order by sal desc) dr from emp)
where dr = &rnk
//
 
SELECT *
 FROM (
   SELECT empno, ename, sal,
   RANK() OVER (ORDER BY sal DESC) EMPRANK
   FROM emp)
//
 
 

[amitpatel66]

hi I want to know about a Query regarding Top 10 salaries from Emp and I want 1 to 10 numbers at the Regarding salaries


I want Out put like 10000 1
7500 2
5500 3
3500 4

 
SELECT salary, rn FROM
(SELECT empno,salary,rownum rn from emp ORDER BY salary desc) WHERE rn <= 10