ALL_CONCAT
Written by
Updated at June 27, 2023
Syntax
Standard
Extended
ALL_CONCAT( expression [ , separator ] )
ALL_CONCAT( expression [ , separator ]
[ FIXED ... | INCLUDE ... | EXCLUDE ... ]
[ BEFORE FILTER BY ... ]
)
More info:
Description
Returns a string that contains all unique values of expression
delimited by separator
(if separator
is not specified, a comma is used).
Argument types:
expression
—Array of fractional numbers | Array of integers | Array of strings | Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID
separator
—String
Return type: String
Note
Only constant values are accepted for the arguments (separator
).
Examples
ALL_CONCAT([Profit])
ALL_CONCAT([Profit], '; ')
Data source support
ClickHouse 21.8
, PostgreSQL 9.3
, YDB
.