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

[code=oracle]
SELECT EMPNO,ENAME,SAL ,DENSE_RANK() OVER (ORDER BY SAL DESC) AS RK FROM EMP ORDER BY SAL DESC
[/code]

[subashsavji]

[code=oracle]


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_he ighest+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)
//

[/code]

[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

[code=oracle]

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

[/code]