Array

ARRAYS_OVERLAP

Snowflake

Mengecek apakah dua array memiliki elemen yang sama.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

ARRAYS_OVERLAP(array1, array2)

Parameter

array1ARRAYwajib

Array pertama

array2ARRAYwajib

Array kedua

Contoh Penggunaan

Check Overlap

SQL

1 SELECT
2   ARRAYS_OVERLAP(ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(2, 3)) as has_overlap,
3   ARRAYS_OVERLAP(ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(3, 4)) as no_overlap;

Cek apakah ada elemen sama.

Hasil

has_overlap: TRUE, no_overlap: FALSE

Kembali ke Snowflake Functions

1	SELECT
2	ARRAYS_OVERLAP(ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(2, 3)) as has_overlap,
3	ARRAYS_OVERLAP(ARRAY_CONSTRUCT(1, 2), ARRAY_CONSTRUCT(3, 4)) as no_overlap;