v.24.12New Feature

Allows Delimiter as Optional Argument in groupConcat Function

Official CH changelog text
Allows to use a delimiter as an optional second argument for aggregate function groupConcat. #72540 (Yarik Briukhovetskyi).
Allows the aggregate function groupConcat to accept an optional second argument for specifying a custom delimiter.

Why it matters

This feature enables users to customize the delimiter used when concatenating grouped values with groupConcat, providing greater flexibility in formatting aggregated string outputs according to user needs.

How to use it

Use the groupConcat aggregate function with an optional second argument to define the delimiter. For example: SELECT groupConcat(column, ', ') FROM table.

Related resources

PreviousNext