Hi All,
From this query i want max rank values only.
SELECT empno, deptno, sal,
DENSE_RANK() OVER (PARTITION BY deptno ORDER BY sal) "rank"
FROM emp;
o/p:
| 7934 | 10 | 1300 | 1 |
| 7902 | 10 | 2222 | 2 |
| 7902 | 10 | 2222 | 2 |
| 7782 | 10 | 2450 | 3 |
| 7839 | 10 | 5000 | 4 |
| 7876 | 20 | 1100 | 1 |
| 7566 | 20 | 2975 | 2 |
| 7902 | 20 | 3000 | 3 |
| 7788 | 20 | 3000 | 3 |
| 7900 | 30 | 900 | 1 |
| 1234 | 30 | 1250 | 2 |
| 7844 | 30 | 1500 | 3 |
| 7499 | 30 | 1600 | 4 |
| 7499 | 30 | 1600 | 4 |
| 7698 | 30 | 2850 | 5 |
required o/p :
| | 7839 | 10 | 5000 | 4 | | 7902 | 20 | 3000 | 3 | | 7788 | 20 | 3000 | 3 | | 7698 | 30 | 2850 | 5 |
| | |