Aggregates
Aggregate
bit_and()
Returns the bitwise AND of all bits in a given expression.
Reference: DuckDB 2.0.0
Arguments & returns
11 overloadsbit_and(arg)
Aggregate
Example
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example with sample data ยท Run to view results.
In other engines
Snowflakebitand_agg()
SELECT BITAND_AGG(int_value) FROM t
SELECT BIT_AND(int_value) FROM t