Aggregate

BIT_AND

MySQL

Melakukan operasi bitwise AND pada semua nilai dalam grup. Mengembalikan hasil AND bit per bit dari semua nilai non-NULL.

Tipe hasil: BIGINT UNSIGNEDDiperbarui: 7 Jan 2026

Syntax

SQL

BIT_AND(expr)

exprintegerwajib

Ekspresi integer untuk operasi bitwise AND

SQL

1 SELECT BIT_AND(permissions) AS common_permissions
2 FROM user_roles
3 WHERE user_id = 1;

Menemukan permission yang dimiliki semua role user.

Hasil

common_permissions: 5 (binary: 101)

SQL

1 SELECT department,
2        BIT_AND(access_flags) AS shared_access
3 FROM employees
4 GROUP BY department;

Menemukan flag akses yang sama di setiap departemen.

Hasil

Sales: 3, Engineering: 7

SQL

1 SELECT BIT_AND(features) AS all_have_features
2 FROM products
3 WHERE category = 'Premium';

Menemukan fitur yang ada di semua produk premium.

Hasil

all_have_features: 12

1	SELECT BIT_AND(permissions) AS common_permissions
2	FROM user_roles
3	WHERE user_id = 1;

1	SELECT department,
2	BIT_AND(access_flags) AS shared_access
3	FROM employees
4	GROUP BY department;

1	SELECT BIT_AND(features) AS all_have_features
2	FROM products
3	WHERE category = 'Premium';