Returns an array containing only the unique elements of the given array. If the given array contains multiple identical members, the returned array will include only a single member of that value. NULL is considered a value like any other, meaning that if the array contains one or more NULLs, the returned array will contain NULL.
Syntax
Parameters
| Parameter | Description | Supported input types |
|---|
<array> | The array to be deduplicated | ARRAY |
Return Type
ARRAY of the same type as the input array
Example
In the following example, the unique levels of the game are returned in an array called levels:
SELECT ARRAY_DISTINCT([1, 1, 2, 2, 3, 4, 1, NULL, 2, NULL]) AS levels;
| levels array(int null) |
|---|
| [1, 2, 3, 4, NULL] |
Rows: 1Execution time: 6.73ms
