Window

PERCENT_RANK

BigQuery

Menghitung percentile rank relatif dari setiap baris. Nilai antara 0 dan 1, menunjukkan persentase baris yang lebih rendah.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

PERCENT_RANK() OVER ([PARTITION BY partition_expression] ORDER BY sort_expression)

Parameter

ORDER BYexpressionwajib

Menentukan urutan

PARTITION BYexpressionopsional

Membagi data ke dalam grup (opsional)

Contoh Penggunaan

Calculate Percentile Rank

SQL

1 SELECT
2   name,
3   salary,
4   PERCENT_RANK() OVER (ORDER BY salary) as percentile
5 FROM `project.dataset.employees`;

Percentile rank untuk gaji.

Hasil

name	salary	percentile
David	50000	0.0
Charlie	70000	0.333
Bob	90000	0.667
Alice	120000	1.0

Performance Percentile

SQL

1 SELECT
2   employee_id,
3   department,
4   performance_score,
5   ROUND(PERCENT_RANK() OVER (PARTITION BY department ORDER BY performance_score) * 100, 1) as percentile
6 FROM `project.dataset.performance`;

Percentile performance dalam department.

Fungsi Terkait

ROW_NUMBERRANKDENSE_RANKCUME_DISTNTILE

Kembali ke BigQuery Functions

1	SELECT
2	name,
3	salary,
4	PERCENT_RANK() OVER (ORDER BY salary) as percentile
5	FROM `project.dataset.employees`;

1	SELECT
2	employee_id,
3	department,
4	performance_score,
5	ROUND(PERCENT_RANK() OVER (PARTITION BY department ORDER BY performance_score) * 100, 1) as percentile
6	FROM `project.dataset.performance`;