Lists & arrays Aggregate

array_agg()

Returns a LIST containing all the values of a column.

Alias of list()

Arguments & returns

Aggregate

Overload link	`arg`	Returns
#01	`T`	`T[]`

SELECT array_agg(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.

COLLECT_LIST(x)

In DuckDB

ARRAY_AGG(x) FILTER(WHERE x IS NOT NULL)

SELECT ARRAY_AGG(x IGNORE NULLS) AS x

In DuckDB

SELECT ARRAY_AGG(x) FILTER(WHERE x IS NOT NULL) AS x

SELECT ARRAY_AGG(DISTINCT a)

In DuckDB

SELECT ARRAY_AGG(DISTINCT a) FILTER(WHERE a IS NOT NULL)