Lists & arrays Scalar

array_unique()

Counts the unique elements of a list.

Arguments & returns

Scalar

Overload link	`list`	Returns
#01	`ANY[]`	`UBIGINT`

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.