BIT_AND

Aggregate Function. Performs an AND operation on each bit between expressions.

Syntax

BIT_AND (<expr1>, <expr2>)

Arguments

  • expression: expressions must be integer data types.

Return Type

Returns the same value as the argument datatype. This will result in a one if the first and second bits are both one. Otherwise, the result will return a zero.

Examples

SELECT group_name, BIT_AND(000) FROM numeric_sample GROUP BY group_name;
+-------------------------+
|group_name | BIT_AND(000)|
+-------------------------+
|epsilon    | 0           |
+-----------|-------------+
|gamma      | 0           |
+-----------|-------------+
|sigma      | 0           |
+-----------|-------------+