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]