Aggregates Aggregate

string_agg()

Concatenates the column string values with an optional separator.

Arguments & returns

2 overloads

Aggregate

Overload link	`str`	Returns
#01	`ANY`	`VARCHAR`

Aggregate

Overload link	`str`	`arg`	Returns
#02	`ANY`	`VARCHAR`	`VARCHAR`

SELECT string_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.