Aggregate

BITAND_AGG

Snowflake

Menghitung bitwise AND agregat dari semua nilai dalam grup. Berguna untuk menganalisis flag bitmap atau permission bits.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

BITAND_AGG(expression)

Parameter

expressionINTEGERwajib

Kolom atau ekspresi numerik integer untuk operasi bitwise AND

Contoh Penggunaan

Mencari Common Permissions

SQL

1 SELECT BITAND_AGG(permission_bits) as common_permissions
2 FROM user_permissions
3 WHERE role = 'admin';

Mencari permission bits yang dimiliki oleh SEMUA admin.

Hasil

Analisis Common Features

SQL

1 SELECT
2   product_category,
3   BITAND_AGG(feature_flags) as common_features,
4   BITOR_AGG(feature_flags) as all_features
5 FROM products
6 GROUP BY product_category;

Membandingkan fitur yang dimiliki semua produk vs fitur yang ada di salah satu produk.

Hasil

PRODUCT_CATEGORY	COMMON_FEATURES	ALL_FEATURES
Electronics	3	255
Clothing	1	31

Fungsi Equivalen di Database Lain

BIT_AND

PostgreSQL

BIT_AND

MySQL

BIT_AND

BigQuery

BIT_AND

DuckDB

Fungsi Terkait

BITOR_AGG

Kembali ke Snowflake Functions

1	SELECT BITAND_AGG(permission_bits) as common_permissions
2	FROM user_permissions
3	WHERE role = 'admin';

1	SELECT
2	product_category,
3	BITAND_AGG(feature_flags) as common_features,
4	BITOR_AGG(feature_flags) as all_features
5	FROM products
6	GROUP BY product_category;