Functions/Lists & arrays/array_unique
Lists & arrays Scalar

array_unique()

Counts the unique elements of a list

Alias of list_unique()

Arguments & returns

array_unique(list)

Scalar
Overload link list Returns
#01 ANY[] UBIGINT

Example

array_unique example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  list_unique([1, 1, NULL, -3, 1, 5]);