ALL_CONCAT

Written by

Updated at November 6, 2024

Standard

Extended

ALL_CONCAT( expression [ , separator ] )

ALL_CONCAT( expression [ , separator ]
            [ FIXED ... | INCLUDE ... | EXCLUDE ... ]
            [ BEFORE FILTER BY ... ]
          )

More info:

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).

ALL_CONCAT([Profit])

ALL_CONCAT([Profit], '; ')

ClickHouse 21.8, Files, Google Sheets, PostgreSQL 9.3, Yandex Documents, YDB.