Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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]