JSON

ARRAY_GENERATE_RANGE

Snowflake

Menghasilkan array dengan sequence angka dari start sampai stop (exclusive).

Tipe hasil: ARRAY

Syntax

SQL

ARRAY_GENERATE_RANGE(start, stop [, step])

Parameter

startINTEGERwajib

Nilai awal (inclusive)

stopINTEGERwajib

Nilai akhir (exclusive)

stepINTEGERopsional

Increment per elemen (default 1)

Contoh Penggunaan

Generate Number Sequence

SQL

1 SELECT
2   ARRAY_GENERATE_RANGE(1, 6) as one_to_five,
3   ARRAY_GENERATE_RANGE(0, 10, 2) as even_numbers,
4   ARRAY_GENERATE_RANGE(10, 0, -2) as descending;

Berbagai sequence angka.

Hasil

one_to_five	even_numbers	descending
[1,2,3,4,5]	[0,2,4,6,8]	[10,8,6,4,2]

Kembali ke Snowflake Functions

1	SELECT
2	ARRAY_GENERATE_RANGE(1, 6) as one_to_five,
3	ARRAY_GENERATE_RANGE(0, 10, 2) as even_numbers,
4	ARRAY_GENERATE_RANGE(10, 0, -2) as descending;