Window

NTILE

BigQuery

Membagi baris dalam partition menjadi sejumlah bucket yang ditentukan dan memberikan nomor bucket ke setiap baris.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

NTILE(num_buckets) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression)

Parameter

num_bucketsINT64wajib

Jumlah bucket untuk membagi data

ORDER BYexpressionwajib

Menentukan urutan sebelum pembagian

PARTITION BYexpressionopsional

Membagi data ke dalam grup (opsional)

Contoh Penggunaan

Membagi ke Quartiles

SQL

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

Membagi karyawan ke 4 grup berdasarkan gaji.

Hasil

name	salary	quartile
David	50000	1
Charlie	70000	2
Bob	90000	3
Alice	120000	4

Decile per Department

SQL

1 SELECT
2   department,
3   name,
4   sales,
5   NTILE(10) OVER (PARTITION BY department ORDER BY sales DESC) as decile
6 FROM `project.dataset.sales_reps`;

Top 10% performers (decile=1) per department.

Fungsi Terkait

ROW_NUMBERRANKDENSE_RANKPERCENT_RANKCUME_DIST

Kembali ke BigQuery Functions

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

1	SELECT
2	department,
3	name,
4	sales,
5	NTILE(10) OVER (PARTITION BY department ORDER BY sales DESC) as decile
6	FROM `project.dataset.sales_reps`;