Aggregate

BIT_OR

MySQL

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

Tipe hasil: BIGINT UNSIGNEDDiperbarui: 7 Jan 2026

Syntax

SQL

BIT_OR(expr)

exprintegerwajib

Ekspresi integer untuk operasi bitwise OR

SQL

1 SELECT BIT_OR(permissions) AS all_permissions
2 FROM user_roles
3 WHERE user_id = 1;

Mengumpulkan semua permission dari semua role user.

Hasil

all_permissions: 15 (binary: 1111)

SQL

1 SELECT department,
2        BIT_OR(capabilities) AS dept_capabilities
3 FROM employees
4 GROUP BY department;

Mengumpulkan semua capability di setiap departemen.

Hasil

Sales: 7, Engineering: 31

SQL

1 SELECT BIT_OR(features) AS available_features
2 FROM products
3 WHERE in_stock = 1;

Mengumpulkan semua fitur dari produk yang tersedia.

Hasil

available_features: 63

1	SELECT BIT_OR(permissions) AS all_permissions
2	FROM user_roles
3	WHERE user_id = 1;

1	SELECT department,
2	BIT_OR(capabilities) AS dept_capabilities
3	FROM employees
4	GROUP BY department;

1	SELECT BIT_OR(features) AS available_features
2	FROM products
3	WHERE in_stock = 1;