Window

NTILE

Snowflake

Membagi rows menjadi N bucket yang sama besar.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

NTILE(num_buckets) OVER ([PARTITION BY ...] ORDER BY ...)

num_bucketsINTEGERwajib

Jumlah bucket

SQL

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

Membagi karyawan menjadi 4 quartile berdasarkan salary.

SQL

1 SELECT
2   customer_id,
3   lifetime_value,
4   NTILE(10) OVER (ORDER BY lifetime_value DESC) as decile
5 FROM customers;

Top 10% customers di decile 1.

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

1	SELECT
2	customer_id,
3	lifetime_value,
4	NTILE(10) OVER (ORDER BY lifetime_value DESC) as decile
5	FROM customers;