ARRAY_DISTINCT

All functions > ARRAY > ARRAY_DISTINCT

Returns an array with distinct elements, sorted in ascending order.

Signatures

Returns: An array with distinct elements sorted in ascending order

ARRAY_DISTINCT(array: ARRAY<T>) → ARRAY<T>

sql

Parameter	Type	Required	Description
`array`	`ARRAY<T>`	Yes	The input array containing possible duplicate elements

Notes

Removes all duplicate elements and sorts the result
Returns sorted distinct elements
Eliminates all duplicates using set semantics
Handles NULL values consistently
Empty arrays remain empty

Aliases

ARRAY_UNIQUE

Examples

FeatureQL

SELECT
    f1 := ARRAY_DISTINCT(ARRAY[1, 2, 2, 3, 3, 3]),  -- Remove duplicate numbers
    f2 := ARRAY_DISTINCT(ARRAY['A', 'B', 'A', 'C', 'B']),  -- Remove duplicate strings
    f3 := ARRAY_DISTINCT(ARRAY['apple', 'banana', 'apple']),  -- Real-world string example
    f4 := ARRAY_DISTINCT(ARRAY[1, 2, 3]),  -- No duplicates to remove
    f5 := ARRAY_DISTINCT(ARRAY[5, 5, 5]),  -- All elements the same
    f6 := ARRAY_DISTINCT(ARRAY[]::BIGINT[])  -- Empty array
;

Result

f1 ARRAY	f2 ARRAY	f3 ARRAY	f4 ARRAY	f5 ARRAY	f6 ARRAY
[1, 2, 3]	[A, B, C]	[apple, banana]	[1, 2, 3]	[5]	[]

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Signatures Notes Aliases Examples