ALL_CONCAT
Syntax
ALL_CONCAT( expression [ , separator ] )
Description
Returns a string that contains all grouped values of expression
delimited by separator
(if separator
is not specified, a comma is used).
Argument types:
expression
—Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID
separator
—String
Return type: String
Note
Only constant values are accepted for arguments (separator
).
Examples
ALL_CONCAT([Profit])
ALL_CONCAT([Profit], '; ')
Data source support
Materialized Dataset
, ClickHouse 1.1
, PostgreSQL 9.3
.