Apa saja parameter fungsi NTILE?

Fungsi ini memiliki 2 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: num_buckets (INT64, wajib): Number of buckets to divide the data into; PARTITION BY (expression, opsional): Divides data into groups (optional); ORDER BY (expression, wajib): Determines the order before division.

Window

NTILE

BigQuery

Divides rows within a partition into a specified number of buckets and assigns a bucket number to each row.

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL

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

Parameter

num_bucketsINT64wajib

Number of buckets to divide the data into

ORDER BYexpressionwajib

Determines the order before division

PARTITION BYexpressionopsional

Divides data into groups (optional)

Contoh Penggunaan

Divide into Quartiles

SQL

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

Divides employees into 4 groups based on salary.

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.

Pertanyaan Umum tentang NTILE

Apa itu fungsi NTILE di BigQuery?

Divides rows within a partition into a specified number of buckets and assigns a bucket number to each row. Di BigQuery, fungsi NTILE termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan NTILE di BigQuery?

Gunakan sintaks berikut: NTILE(num_buckets) OVER ([PARTITION BY partition_expression] ORDER BY sort_expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi NTILE?

Fungsi NTILE mengembalikan nilai bertipe INT64. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Fungsi Terkait

ROW_NUMBERRANKDENSE_RANKPERCENT_RANKCUME_DIST

Ngulik Langsung

Sudah paham NTILE? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

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`;