Link Search Menu Expand Document


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.




Parameter Description Supported input types
<array> The array to be deduplicated ARRAY

Return Type

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 levels:

	ARRAY_DISTINCT([ 1, 1, 2, 2, 3, 4, 1, NULL, 2, NULL ]) AS levels;

Returns: [1,2,3,4,NULL]