Window

NTILE

DuckDB

Membagi baris menjadi n kelompok (buckets) yang kurang lebih sama besar dan memberikan nomor kelompok ke setiap baris.

Tipe hasil: BIGINTDiperbarui: 6 Jan 2026

Syntax

SQL

NTILE(n) OVER ([PARTITION BY col] ORDER BY col)

nINTEGERwajib

Jumlah kelompok yang diinginkan

ORDER BYclausewajib

Menentukan urutan pembagian kelompok

PARTITION BYclauseopsional

Opsional. Membagi hasil menjadi partisi terpisah

SQL

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

Membagi karyawan ke 4 kelompok berdasarkan gaji.

Hasil

SQL

1 SELECT
2   customer_id,
3   total_spending,
4   NTILE(10) OVER (ORDER BY total_spending DESC) as spending_decile
5 FROM customer_spending;

Membagi customer ke 10 kelompok berdasarkan spending.

SQL

1 SELECT
2   category,
3   product_name,
4   price,
5   NTILE(4) OVER (PARTITION BY category ORDER BY price) as price_quartile
6 FROM products;

Membuat quartiles harga untuk setiap kategori produk.

SQL

1 SELECT *
2 FROM (
3   SELECT
4     *,
5     NTILE(10) OVER (ORDER BY score DESC) as decile
6   FROM students
7 ) sub
8 WHERE decile = 1;

Mengambil 10% siswa dengan score tertinggi.

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

1	SELECT
2	customer_id,
3	total_spending,
4	NTILE(10) OVER (ORDER BY total_spending DESC) as spending_decile
5	FROM customer_spending;

1	SELECT
2	category,
3	product_name,
4	price,
5	NTILE(4) OVER (PARTITION BY category ORDER BY price) as price_quartile
6	FROM products;

1	SELECT *
2	FROM (
3	SELECT
4	*,
5	NTILE(10) OVER (ORDER BY score DESC) as decile
6	FROM students
7	) sub
8	WHERE decile = 1;