PERCENTILE_DISC

1
SELECT 
2
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY rating) AS median_rating
3
FROM reviews;

1
SELECT 
2
  PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY score) AS cont_median,
3
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY score) AS disc_median
4
FROM (
5
  VALUES (1), (2), (3), (4)
6
) AS t(score);

1
SELECT *
2
FROM employees
3
WHERE performance_score >= (
4
  SELECT PERCENTILE_DISC(0.9) 
5
  WITHIN GROUP (ORDER BY performance_score)
6
  FROM employees
7
);