ARRAY_INTERSECT
Returns the intersection of two arrays.
Analyze Syntax
func.array_intersect([1,2,3], [2,3,4])
Analyze Examples
func.array_intersect([1, 2, 3], [2, 3, 4])
┌───────┐
│ [2,3] │
└───────┘
SQL Syntax
ARRAY_INTERSECT([1,2,3], [2,3,4])
SQL Examples
SELECT ARRAY_INTERSECT([1, 2, 3], [2, 3, 4]);
┌───────┐
│ [2,3] │
└───────┘