array_intersect()

Returns a list containing the distinct elements that are present in both list1 and list2.

Reference: DuckDB 2.0.0

Alias of list_intersect()

Arguments & returns

array_intersect(list1, list2)

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

Example

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

Engine example · Run to view results.