Aggregate

BIT_AND

BigQuery

Melakukan operasi bitwise AND pada semua nilai dalam group. Menghasilkan nilai di mana setiap bit adalah 1 hanya jika semua nilai memiliki bit tersebut sebagai 1.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

BIT_AND(expression)

Parameter

expressionINT64wajib

Kolom atau ekspresi integer yang akan di-AND kan

Contoh Penggunaan

Common Permission Flags

SQL

1 SELECT
2   user_group,
3   BIT_AND(permissions) as common_permissions
4 FROM `project.dataset.user_permissions`
5 GROUP BY user_group;

Mencari permission yang dimiliki SEMUA user dalam group.

Hasil

user_group	common_permissions
admin	255 (all flags)
editor	7 (read+write+execute)
viewer	1 (read only)

Feature Flags Analysis

SQL

1 SELECT
2   BIT_AND(feature_flags) as all_users_have,
3   BIT_OR(feature_flags) as any_user_has
4 FROM `project.dataset.user_settings`;

Menganalisis feature flags yang dimiliki semua vs sebagian users.

Hasil

all_users_have	any_user_has
3	255

Common Bits per Category

SQL

1 SELECT
2   category,
3   BIT_AND(status_flags) as common_flags,
4   FORMAT('%b', BIT_AND(status_flags)) as binary_representation
5 FROM `project.dataset.items`
6 GROUP BY category;

Melihat common flags dalam format binary.

Hasil

category	common_flags	binary_representation
Electronics	6	110
Fashion	2	10

Fungsi Terkait

BIT_ORBIT_XOR

Kembali ke BigQuery Functions

1	SELECT
2	user_group,
3	BIT_AND(permissions) as common_permissions
4	FROM `project.dataset.user_permissions`
5	GROUP BY user_group;

1	SELECT
2	BIT_AND(feature_flags) as all_users_have,
3	BIT_OR(feature_flags) as any_user_has
4	FROM `project.dataset.user_settings`;

1	SELECT
2	category,
3	BIT_AND(status_flags) as common_flags,
4	FORMAT('%b', BIT_AND(status_flags)) as binary_representation
5	FROM `project.dataset.items`
6	GROUP BY category;