BIT_OR
Returns the bitwise OR of non-NULL input values.
Syntax
BIT_OR(expression int) → int
expression: An expression that evaluates to a data type that can be cast as an integer.
Examples
SELECT BIT_OR(passenger_count)
FROM eth.recent_blocks
-- EXPR$0
-- 255
SELECT total_gas_used,
BIT_OR(transaction_count)
FROM eth.recent_blocks
GROUP BY total_gas_used
-- total_gas_used, EXPR$1
-- 29.0, 7
-- 5.5, 15
Usage Notes
If no rows match, returns a value with all bits set to 0. NULL values have no effect on the result unless all results are NULL, which is treated as no match.
Last updated
Was this helpful?