Window

WIDTH_BUCKET

Snowflake

Menempatkan nilai ke dalam bucket dengan lebar yang sama (equi-width histogram).

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

WIDTH_BUCKET(expr, min_value, max_value, num_buckets)

exprnumericwajib

Nilai untuk di-bucket

min_valuenumericwajib

Batas minimum range

max_valuenumericwajib

Batas maksimum range

num_bucketsINTEGERwajib

Jumlah bucket

SQL

1 SELECT
2   customer_name,
3   age,
4   WIDTH_BUCKET(age, 0, 100, 10) as age_bucket
5 FROM customers;

Membagi umur ke 10 bucket (0-10, 10-20, dst).

SQL

1 SELECT
2   WIDTH_BUCKET(price, 0, 1000, 5) as price_range,
3   COUNT(*) as product_count
4 FROM products
5 GROUP BY 1
6 ORDER BY 1;

Distribusi produk per range harga.

1	SELECT
2	customer_name,
3	age,
4	WIDTH_BUCKET(age, 0, 100, 10) as age_bucket
5	FROM customers;

1	SELECT
2	WIDTH_BUCKET(price, 0, 1000, 5) as price_range,
3	COUNT(*) as product_count
4	FROM products
5	GROUP BY 1
6	ORDER BY 1;