BIT_OR
Aggregate Function. Performs an OR operation on each bit between expressions.
Syntax
BIT_OR (<expr1>, <expr2>)
Arguments
expression: expressions must be integer data types.
Return Type
This will result is a one if two of the corresponding bits are different. If the bits are the same it will return a zero.
Examples
SELECT group_name, BIT_OR(01) FROM numeric_sample GROUP BY group_name; +-------------------------+ |group_name | BIT_AND(01) | +-------------------------+ |epsilon | 1 | +-----------|-------------+ |gamma | 1 | +-----------|-------------+ |sigma | 1 | +-----------|-------------+