DENSE_RANK

1
SELECT
2
  name,
3
  score,
4
  RANK() OVER (ORDER BY score DESC) as rank,
5
  DENSE_RANK() OVER (ORDER BY score DESC) as dense_rank
6
FROM `project.dataset.students`;

1
WITH ranked AS (
2
  SELECT
3
    category,
4
    product_name,
5
    sales,
6
    DENSE_RANK() OVER (PARTITION BY category ORDER BY sales DESC) as dr
7
  FROM `project.dataset.products`
8
)
9
SELECT * FROM ranked WHERE dr <= 3;