This is a document Template
 
RANK:

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: Skips rank for a tie, there was no rank 2.

 

Oracle DENSE_RANK : Rank number series maintained chronological order.

PostgreSQL:

RANK: Note rank 2 is skipped.

DENSE_RANK