ARRAY_DISTINCT
Returns an array containing only the unique elements of the given array. In other words, if the given array contains multiple identical members, the returned array will include only a single member of that value.
Syntax
ARRAY_DISTINCT(<arr>)
| Parameter | Description |
|---|---|
<arr> | The array to be analyzed for unique members. |
Example
SELECT
ARRAY_DISTINCT([ 1, 1, 2, 2, 3, 4 ]) AS res;
Returns: [1,2,3,4]