ARRAY_CONCAT
Combines one or more arrays that are passed as arguments.
Syntax
ARRAY_CONCAT(<array> [, ...n])
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> [, ...n] | The arrays to be combined. If only one array is given, an identical array is returned. | ARRAY |
Return Type
ARRAY of the same type as the input arrays
Example
In the following example, two arrays are combined to show all of the levels in a particular game:
SELECT
ARRAY_CONCAT([ 1, 2, 3, 4 ], [ 5, 6, 7, 8, 9, 10 ]) AS levels;
Returns: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]