ARRAY_DISTINCT
Introduced or updated: v1.2.762
Removes duplicate elements from a JSON array and returns an array with only distinct elements.
Aliases
JSON_ARRAY_DISTINCT
Syntax
ARRAY_DISTINCT(<json_array>)
Return Type
JSON array.
Examples
SELECT ARRAY_DISTINCT('["apple", "banana", "apple", "orange", "banana"]'::VARIANT);
-[ RECORD 1 ]-----------------------------------
array_distinct('["apple", "banana", "apple", "orange", "banana"]'::VARIANT): ["apple","banana","orange"]