Aggregate

BIT_AND

BigQuery

Performs a bitwise AND operation across all values in a group. Returns a value where each bit is 1 only if all input values have that bit set to 1.

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL

BIT_AND(expression)

Parameter

expressionINT64wajib

The integer column or expression to AND together

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;

Finds the permissions held by ALL users within each 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`;

Analyzes which feature flags are held by all users versus at least one user.

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;

Views common flags in binary format.

Hasil

category	common_flags	binary_representation
Electronics	6	110
Fashion	2	10

Pertanyaan Umum tentang BIT_AND

Apa itu fungsi BIT_AND di BigQuery?

Performs a bitwise AND operation across all values in a group. Returns a value where each bit is 1 only if all input values have that bit set to 1. Di BigQuery, fungsi BIT_AND termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan BIT_AND di BigQuery?

Gunakan sintaks berikut: BIT_AND(expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi BIT_AND?

Fungsi BIT_AND mengembalikan nilai bertipe INT64. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Apa saja parameter fungsi BIT_AND?

Fungsi ini memiliki 1 parameter wajib. Parameter yang digunakan: expression (INT64, wajib): The integer column or expression to AND together.

Fungsi Terkait

BIT_ORBIT_XOR

Ngulik Langsung

Sudah paham BIT_AND? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

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;