Ranking Functions

These assign ranks or row numbers within partitions.

ROW_NUMBER

SELECT first_name, salary,
       ROW_NUMBER() OVER (ORDER BY salary DESC) AS rank
FROM employees;

RANK

Gaps are introduced in ranking.

DENSE_RANK

No gaps in ranking.