Skip to main content

LIST

Aggregate function.

The LIST() function converts all the values of a column to an Array.

Syntax​

LIST(expression)

Arguments​

ArgumentsDescription
expressionAny expression

Return Type​

the Array type that use the type of the value as inner type.

Examples​

SELECT LIST(number) FROM numbers(10);
+-----------------------+
| list(number)          |
+-----------------------+
| [0,1,2,3,4,5,6,7,8,9] |
+-----------------------+