Returns the relative rank of a row as a value between 0 and 1.
Syntax
PERCENT_RANK() OVER (w)Example
Enter values below to update the example in real time.
employee_id→salary→pct_rank→employees→-- 급여 백분위 순위
SELECT employee_id, salary,
ROUND(PERCENT_RANK() OVER (ORDER BY salary), 4) AS pct_rank
FROM employees;