GROUP_BIT_XOR
Description
Performs a bitwise xor operation on all values in a single integer column or expression.
Syntax
GROUP_BIT_XOR(<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_xor(value) from group_bit;+------------------------+
| group_bit_xor(`value`) |
+------------------------+
| 4 |
+------------------------+