Array functions
ARRAY_DISTINCT
Reference material for ARRAY_DISTINCT function
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
:
Returns: [1,2,3,4,NULL]