Functions/Aggregates/bit_and

Aggregates Aggregate

bit_and()

Returns the bitwise AND of all bits in a given expression.

Arguments & returns

11 overloads

`bit_and(arg)`

Aggregate

Overload link	`arg`	Returns
#01	`BIGINT`	`BIGINT`
#02	`BIT`	`BIT`
#03	`HUGEINT`	`HUGEINT`
#04	`INTEGER`	`INTEGER`
#05	`SMALLINT`	`SMALLINT`
#06	`TINYINT`	`TINYINT`
#07	`UBIGINT`	`UBIGINT`
#08	`UHUGEINT`	`UHUGEINT`
#09	`UINTEGER`	`UINTEGER`
#10	`USMALLINT`	`USMALLINT`
#11	`UTINYINT`	`UTINYINT`

Example

SELECT bit_and(A)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

In other engines

BigQuery`bit_and()`

Snowflake`bitand_agg()`

SELECT BITAND_AGG(int_value) FROM t

In DuckDB

SELECT BIT_AND(int_value) FROM t

SQLGlot example ↗

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3