Aggregates
Aggregate
group_concat()
Concatenates the column string values with an optional separator.
Reference: DuckDB 1.3.2
Alias of string_agg()
Arguments & returns
2 overloadsgroup_concat(str)
Aggregate
| Overload link | str |
Returns |
|---|---|---|
| #01 | ANY |
VARCHAR |
group_concat(str, arg)
Aggregate
| Overload link | str | arg |
Returns |
|---|---|---|---|
| #02 | ANY | VARCHAR |
VARCHAR |
Example
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example with sample data · Run to view results.
Catalog examples
SELECT
string_agg(A, '-');