RANK

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

1
SELECT
2
  category,
3
  product_name,
4
  sales,
5
  RANK() OVER (PARTITION BY category ORDER BY sales DESC) as sales_rank
6
FROM products;

1
SELECT
2
  name,
3
  score,
4
  ROW_NUMBER() OVER (ORDER BY score DESC) as row_num,
5
  RANK() OVER (ORDER BY score DESC) as rank,
6
  DENSE_RANK() OVER (ORDER BY score DESC) as dense_rank
7
FROM students;