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

ARRAY_DISTINCT(<array>)

​
Parameters

ParameterDescriptionSupported input types
<array>The array to be deduplicatedARRAY

​
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;

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