0~1 범위의 상대적 순위를 반환합니다.
문법
PERCENT_RANK() OVER (w)예제
아래 값을 입력하면 예제에 즉시 반영됩니다.
employee_id→salary→pct_rank→employees→SELECT employee_id, salary,
ROUND(PERCENT_RANK() OVER (ORDER BY salary), 4) AS pct_rank
FROM employees;
0~1 범위의 상대적 순위를 반환합니다.
PERCENT_RANK() OVER (w)아래 값을 입력하면 예제에 즉시 반영됩니다.
employee_id→salary→pct_rank→employees→SELECT employee_id, salary,
ROUND(PERCENT_RANK() OVER (ORDER BY salary), 4) AS pct_rank
FROM employees;