Returns a percentile based on a continuous distribution.
Syntax
PERCENTILE_CONT(p) WITHIN GROUP (ORDER BY ...)Example
Enter values below to update the example in real time.
PERCENTILE_CONT→salary→median_salary→employees→-- 급여 중앙값
SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary) OVER () AS median_salary
FROM employees;