Skip to main content
These functions can be used to convert string column values into delimited lists of those values.

STRING_AGG(expr[, delim])

Combines column values within a group into a single delimited string of those values.The default delimiter is a comma.

STRING_AGG_DISTINCT(expr[, delim])

Combines column values within a group into a single delimited string of those values, removing any duplicates.The default delimiter is a comma.