ARRAY_CONTAINS_SEQ
Learn how to use the ARRAY_CONTAINS_SEQ array function in PlaidCloud Lakehouse. Checks whether an array contains all elements of another array in order.
Checks whether an array contains all elements of another array in order.
Analyze Syntax
func.array_contains_seq([1,2,3], [1,2])
Analyze Examples
func.array_contains_seq([1, 2, 3, 4], [2, 3])
┌───┐
│ 1 │
└───┘
SQL Syntax
ARRAY_CONTAINS_SEQ([1,2,3], [1,2])
SQL Examples
SELECT ARRAY_CONTAINS_SEQ([1, 2, 3, 4], [2, 3]);
┌───┐
│ 1 │
└───┘