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.
|Parameter||Description||Supported input types|
| ||The array to be analyzed for unique members|| |
ARRAY of the same type as the input array
In the following example, the unique levels of the game are returned in an array called
SELECT ARRAY_DISTINCT([ 1, 1, 2, 2, 3, 4 ]) AS levels;