DENSE_RANK

1
SELECT
2
  name,
3
  score,
4
  DENSE_RANK() OVER (ORDER BY score DESC) as dense_rank
5
FROM students;

1
SELECT DISTINCT salary
2
FROM (
3
  SELECT
4
    salary,
5
    DENSE_RANK() OVER (ORDER BY salary DESC) as dr
6
  FROM employees
7
) sub
8
WHERE dr <= 3;

1
SELECT
2
  department,
3
  name,
4
  performance_score,
5
  DENSE_RANK() OVER (PARTITION BY department ORDER BY performance_score DESC) as perf_rank
6
FROM employees;