Aggregates Aggregate

bitstring_agg()

Returns a bitstring with bits set for each distinct value.

Reference: DuckDB 2.0.0

Arguments & returns

20 overloads

bitstring_agg(arg)

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

bitstring_agg(arg, min, max)

Aggregate
Overload link argminmax Returns
#11 BIGINTBIGINTBIGINT BIT
#12 HUGEINTHUGEINTHUGEINT BIT
#13 INTEGERINTEGERINTEGER BIT
#14 SMALLINTSMALLINTSMALLINT BIT
#15 TINYINTTINYINTTINYINT BIT
#16 UBIGINTUBIGINTUBIGINT BIT
#17 UHUGEINTUHUGEINTUHUGEINT BIT
#18 UINTEGERUINTEGERUINTEGER BIT
#19 USMALLINTUSMALLINTUSMALLINT BIT
#20 UTINYINTUTINYINTUTINYINT BIT

Example

bitstring_agg example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Guide example ยท Run to view results.

Catalog examples

SELECT
  bitstring_agg(A);