array_distinct()

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

Reference: DuckDB 2.0.0

Alias of list_distinct()

Arguments & returns

array_distinct(list)

Scalar
Overload link list Returns
#01 T[] T[]

Example

array_distinct example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.