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 |
+------------------------+