PERCENT_RANK

1
SELECT 
2
  name,
3
  salary,
4
  PERCENT_RANK() OVER (ORDER BY salary) AS percentile
5
FROM employees;

1
SELECT *
2
FROM (
3
  SELECT 
4
    product_name,
5
    sales,
6
    PERCENT_RANK() OVER (ORDER BY sales DESC) AS pct_rank
7
  FROM products
8
) ranked
9
WHERE pct_rank <= 0.1;

1
SELECT 
2
  score,
3
  PERCENT_RANK() OVER (ORDER BY score) AS pct_rank,
4
  CUME_DIST() OVER (ORDER BY score) AS cume_dist
5
FROM test_results;