Window

PERCENT_RANK

Snowflake

Menghitung relative rank (0-1) dari setiap baris dalam partition.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

PERCENT_RANK() OVER ([PARTITION BY ...] ORDER BY ...)

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT
2   employee_name,
3   salary,
4   PERCENT_RANK() OVER (ORDER BY salary) as pct_rank
5 FROM employees;

Relative rank untuk salary.

Hasil

1	SELECT
2	employee_name,
3	salary,
4	PERCENT_RANK() OVER (ORDER BY salary) as pct_rank
5	FROM employees;