GROUP_BIT_OR
Descriptionβ
Performs a bitwise OR operation on all values in a single integer column or expression.
Syntaxβ
GROUP_BIT_OR(<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 |
+-------+
mysql> select group_bit_or(value) from group_bit;
+-----------------------+
| group_bit_or(`value`) |
+-----------------------+
| 7 |
+-----------------------+