Link Search Menu Expand Document

ARRAY_DISTINCT

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.

Syntax

ARRAY_DISTINCT(<array>)

Parameters

Parameter Description Supported input types
<array> The array to be analyzed for unique members ARRAY

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 ]) AS levels;

Returns: [1,2,3,4]