PERCENTILE_CONT

1
SELECT 
2
  PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary) AS median_salary
3
FROM employees;

1
SELECT 
2
  PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY price) AS q1,
3
  PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median,
4
  PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY price) AS q3
5
FROM products;

1
SELECT 
2
  category,
3
  PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS median_price
4
FROM products
5
GROUP BY category;