Array

ARRAY

BigQuery

Membuat array dari subquery atau literal elements.

Tipe hasil: ARRAY<T>Diperbarui: 7 Jan 2026

Syntax

SQL

ARRAY(subquery) | [element1, element2, ...]

subquery/elementsanywajib

Subquery yang mengembalikan satu kolom atau literal elements

SQL

1 SELECT
2   [1, 2, 3] as literal_array,
3   ARRAY(SELECT x FROM UNNEST([1, 2, 3]) x WHERE x > 1) as from_subquery;

Dua cara membuat array.

Hasil

literal_array	from_subquery
[1, 2, 3]	[2, 3]

1	SELECT
2	[1, 2, 3] as literal_array,
3	ARRAY(SELECT x FROM UNNEST([1, 2, 3]) x WHERE x > 1) as from_subquery;