Array

ARRAY_SLICE

Snowflake

Mengambil subset dari array berdasarkan indeks.

Tipe hasil: ARRAYDiperbarui: 6 Jan 2026

Syntax

SQL

ARRAY_SLICE(array, from, to)

arrayARRAYwajib

Array sumber

fromINTEGERwajib

Indeks awal (0-based, inclusive)

toINTEGERwajib

Indeks akhir (exclusive)

SQL

1 SELECT ARRAY_SLICE(ARRAY_CONSTRUCT(1, 2, 3, 4, 5), 1, 4) as sliced;

Mengambil elemen index 1-3.

Hasil

[2,3,4]