Array

LIST_ELEMENT

DuckDB

Mengambil elemen pada posisi tertentu dari list/array. Alias dari bracket notation list[index].

Tipe hasil: Tipe elemen listDiperbarui: 6 Jan 2026

Syntax

SQL

LIST_ELEMENT(list, index) | list[index]

Parameter

listLISTwajib

List/array sumber

indexINTEGERwajib

Posisi elemen (1-based, atau negatif dari akhir)

Contoh Penggunaan

Mengambil Elemen dari List

SQL

1 SELECT
2   arr,
3   LIST_ELEMENT(arr, 1) as first,
4   LIST_ELEMENT(arr, 2) as second,
5   LIST_ELEMENT(arr, -1) as last
6 FROM (
7   SELECT [10, 20, 30, 40, 50] as arr
8 );

Mengambil elemen pertama, kedua, dan terakhir.

Hasil

arr	first	second	last
[10, 20, 30, 40, 50]	10	20	50

Menggunakan Bracket Notation

SQL

1 SELECT
2   tags,
3   tags[1] as primary_tag,
4   tags[2] as secondary_tag
5 FROM articles;

Bracket notation lebih ringkas dari LIST_ELEMENT.

Hasil

tags	primary_tag	secondary_tag
[sql, database, query]	sql	database
[python, data, analysis]	python	data

Safe Element Access

SQL

1 SELECT
2   arr,
3   LIST_ELEMENT(arr, 1) as elem_1,
4   LIST_ELEMENT(arr, 5) as elem_5,
5   COALESCE(LIST_ELEMENT(arr, 5), 'N/A') as elem_5_safe
6 FROM (
7   SELECT ['a', 'b', 'c'] as arr
8 );

Handling index yang melebihi ukuran list.

Hasil

arr	elem_1	elem_5	elem_5_safe
[a, b, c]	a	NULL	N/A

Kembali ke DuckDB Functions

1	SELECT
2	arr,
3	LIST_ELEMENT(arr, 1) as first,
4	LIST_ELEMENT(arr, 2) as second,
5	LIST_ELEMENT(arr, -1) as last
6	FROM (
7	SELECT [10, 20, 30, 40, 50] as arr
8	);

1	SELECT
2	tags,
3	tags[1] as primary_tag,
4	tags[2] as secondary_tag
5	FROM articles;

1	SELECT
2	arr,
3	LIST_ELEMENT(arr, 1) as elem_1,
4	LIST_ELEMENT(arr, 5) as elem_5,
5	COALESCE(LIST_ELEMENT(arr, 5), 'N/A') as elem_5_safe
6	FROM (
7	SELECT ['a', 'b', 'c'] as arr
8	);