Array

ORDINAL

BigQuery

Mengakses elemen array menggunakan one-based index.

Tipe hasil: Element typeDiperbarui: 7 Jan 2026

Syntax

SQL

array[ORDINAL(one_based_index)]

one_based_indexINT64wajib

Index dimulai dari 1

SQL

1 SELECT
2   arr[ORDINAL(1)] as first,
3   arr[ORDINAL(3)] as third
4 FROM (SELECT ['a', 'b', 'c', 'd'] as arr);

Mengakses elemen dengan one-based index.

Hasil

first	third
a	c