DENSE_RANK

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

1
WITH ranked_salaries AS (
2
  SELECT
3
    employee_name,
4
    department,
5
    salary,
6
    DENSE_RANK() OVER (ORDER BY salary DESC) as salary_rank
7
  FROM employees
8
)
9
SELECT * FROM ranked_salaries WHERE salary_rank <= 3;

1
SELECT
2
  product_name,
3
  revenue,
4
  DENSE_RANK() OVER (ORDER BY revenue DESC) as revenue_rank,
5
  COUNT(*) OVER () as total_products
6
FROM products;