BIT_AND

1
-- Permission flags: 1=read, 2=write, 4=delete, 8=admin
2
SELECT
3
  role_name,
4
  BIT_AND(permissions) as common_permissions
5
FROM users
6
GROUP BY role_name;

1
SELECT
2
  product_line,
3
  BIT_AND(feature_flags) as common_features,
4
  COUNT(*) as product_count
5
FROM products
6
GROUP BY product_line;

1
SELECT
2
  category,
3
  BIT_AND(status_flags) as common_flags,
4
  TO_BASE(BIT_AND(status_flags), 2) as binary_repr
5
FROM items
6
GROUP BY category;