Skip to contents

Removes all duplicates and NULL values from a list. Does not preserve the original order.

Usage

array_distinct(list = `T[]`)

Arguments

list

T[]

Value

T[]

SQL examples

array_distinct([1, 1, NULL, -3, 1, 5])