arrayAgg

This section contains reference documentation for the ARRAY_AGG function.

Concatenates the input values into an array.

Signature

ARRAY_AGG(dataColumn, 'dataType', [isDistinct])

Usage Examples

SELECT ARRAY_AGG(firstName, 'STRING', true) AS firstNames from transcript;

firstNames
Bob,Nick,Lucy