This is a
SELECT ENAME,SAL,RANK() OVER(ORDER BY SAL)"RANK"FROM emp WHERE JOB = 'SALESMAN'
DENSE_RANK:
SELECT ENAME,SAL,DENSE_RANK() OVER(ORDER BY SAL)"D-RANK"FROM emp WHERE JOB = 'SALESMAN'
RANK: Note rank 2 is skipped.
DENSE_RANK