GROUP_BIT_AND
Description
Performs a bitwise AND operation on all values in a single integer column or expression.
Syntax
GROUP_BIT_AND(<expr>)
Parameters
Parameter | Description |
---|---|
<expr> | Supports all INT types |
Return Value
Returns an integer value.
Example
select * from group_bit;
+-------+
| value |
+-------+
| 3 |
| 1 |
| 2 |
| 4 |
+-------+
select group_bit_and(value) from group_bit;
+------------------------+
| group_bit_and(`value`) |
+------------------------+
| 0 |
+------------------------+