DEDUP

DEDUP removes duplicate elements from a list while preserving order.

Syntax

DEDUP(list)

Parameters

• list – List value to process.

Examples

SELECT DEDUP(CAST('[1, 2, 3, 3, 4, 5, 5]' AS LIST));

This returns [1, 2, 3, 4, 5].

Notes

A non-list argument results in an error.