Aggregate

BITOR_AGG

Snowflake

Menghitung bitwise OR agregat dari semua nilai dalam grup. Berguna untuk mengumpulkan semua flags atau features yang ada di grup.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

BITOR_AGG(expression)

expressionINTEGERwajib

Kolom atau ekspresi numerik integer untuk operasi bitwise OR

SQL

1 SELECT BITOR_AGG(permission_bits) as all_permissions
2 FROM user_permissions
3 WHERE user_id = 'U001';

Mengumpulkan semua permission bits yang dimiliki user di semua rolenya.

Hasil

255

SQL

1 SELECT
2   category,
3   BITOR_AGG(feature_flags) as all_features_in_category,
4   COUNT(*) as product_count
5 FROM products
6 GROUP BY category;

Mengumpulkan semua fitur yang tersedia di setiap kategori.

Hasil

CATEGORY	ALL_FEATURES_IN_CATEGORY	PRODUCT_COUNT
Electronics	255	150
Furniture	63	80

BIT_OR

PostgreSQL

BIT_OR

MySQL

BIT_OR

BigQuery

BIT_OR

DuckDB

1	SELECT BITOR_AGG(permission_bits) as all_permissions
2	FROM user_permissions
3	WHERE user_id = 'U001';

1	SELECT
2	category,
3	BITOR_AGG(feature_flags) as all_features_in_category,
4	COUNT(*) as product_count
5	FROM products
6	GROUP BY category;