Window

PERCENTILE_CONT

BigQuery

Menghitung nilai percentile kontinu dengan interpolasi linear dari nilai-nilai dalam grup.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

PERCENTILE_CONT(expression, percentile) OVER ([PARTITION BY partition_expression])

Parameter

expressionFLOAT64/INT64wajib

Kolom numerik untuk menghitung percentile

percentileFLOAT64wajib

Nilai percentile antara 0 dan 1

PARTITION BYexpressionopsional

Membagi data ke dalam grup

Contoh Penggunaan

Menghitung Median Gaji

SQL

1 SELECT
2   department,
3   name,
4   salary,
5   PERCENTILE_CONT(salary, 0.5) OVER (PARTITION BY department) as median_salary
6 FROM `project.dataset.employees`;

Median gaji per department menggunakan interpolasi.

Hasil

department	name	salary	median_salary
Sales	David	50000	75000.0
Sales	Bob	80000	75000.0
Sales	Alice	120000	75000.0

Multiple Percentiles

SQL

1 SELECT
2   category,
3   PERCENTILE_CONT(price, 0.25) OVER (PARTITION BY category) as p25,
4   PERCENTILE_CONT(price, 0.5) OVER (PARTITION BY category) as median,
5   PERCENTILE_CONT(price, 0.75) OVER (PARTITION BY category) as p75
6 FROM `project.dataset.products`;

Quartiles harga per kategori.

Fungsi Terkait

STDDEVVARIANCECORRCOVAR_POPCOVAR_SAMPPERCENTILE_DISCSTDDEV_POPSTDDEV_SAMPVAR_POPVAR_SAMP

Kembali ke BigQuery Functions

1	SELECT
2	department,
3	name,
4	salary,
5	PERCENTILE_CONT(salary, 0.5) OVER (PARTITION BY department) as median_salary
6	FROM `project.dataset.employees`;

1	SELECT
2	category,
3	PERCENTILE_CONT(price, 0.25) OVER (PARTITION BY category) as p25,
4	PERCENTILE_CONT(price, 0.5) OVER (PARTITION BY category) as median,
5	PERCENTILE_CONT(price, 0.75) OVER (PARTITION BY category) as p75
6	FROM `project.dataset.products`;