The short answer
Suppose salaries are:
100
100
90
80Results:
ROW_NUMBER: 1 2 3 4
RANK: 1 1 3 4
DENSE_RANK: 1 1 2 3ROW_NUMBER
Every row gets a unique number.
RANK
Ties receive the same rank, and gaps are created.
DENSE_RANK
Ties receive the same rank, but no gaps.