Array

LIST_REVERSE

DuckDB

Membalik urutan elemen dalam list/array. Elemen pertama menjadi terakhir dan sebaliknya.

Tipe hasil: LIST (sama dengan tipe input)Diperbarui: 6 Jan 2026

Syntax

SQL

LIST_REVERSE(list)

Parameter

listLISTwajib

List/array yang akan dibalik urutannya

Contoh Penggunaan

Membalik Urutan List

SQL

1 SELECT
2   original_list,
3   LIST_REVERSE(original_list) as reversed
4 FROM (
5   SELECT [1, 2, 3, 4, 5] as original_list UNION ALL
6   SELECT ['a', 'b', 'c'] UNION ALL
7   SELECT [10, 20, 30, 40]
8 );

Membalik urutan elemen dalam list.

Hasil

original_list	reversed
[1, 2, 3, 4, 5]	[5, 4, 3, 2, 1]
[a, b, c]	[c, b, a]
[10, 20, 30, 40]	[40, 30, 20, 10]

Reverse Chronological Order

SQL

1 SELECT
2   user_id,
3   LIST_REVERSE(LIST(event_name ORDER BY event_time)) as events_newest_first
4 FROM user_events
5 GROUP BY user_id;

Mengurutkan events dengan yang terbaru di awal.

Hasil

user_id	events_newest_first
1	[logout, page_view, login]
2	[purchase, add_cart, view]

Stack Operations (LIFO)

SQL

1 SELECT
2   stack_name,
3   items as stack_items,
4   items[-1] as top_item,
5   LIST_REVERSE(items)[1] as bottom_item
6 FROM stacks;

Mengakses top dan bottom dari stack.

Hasil

stack_name	stack_items	top_item	bottom_item
Task Queue	[A, B, C, D]	D	A
Undo Stack	[edit1, edit2]	edit2	edit1

Fungsi Equivalen di Database Lain

ARRAY_REVERSE

BigQuery

Fungsi Terkait

LIST_APPENDLIST_PREPENDLIST_CONCATLIST_DISTINCTLIST_SORTLIST_FILTER

Kembali ke DuckDB Functions

1	SELECT
2	original_list,
3	LIST_REVERSE(original_list) as reversed
4	FROM (
5	SELECT [1, 2, 3, 4, 5] as original_list UNION ALL
6	SELECT ['a', 'b', 'c'] UNION ALL
7	SELECT [10, 20, 30, 40]
8	);

1	SELECT
2	user_id,
3	LIST_REVERSE(LIST(event_name ORDER BY event_time)) as events_newest_first
4	FROM user_events
5	GROUP BY user_id;

1	SELECT
2	stack_name,
3	items as stack_items,
4	items[-1] as top_item,
5	LIST_REVERSE(items)[1] as bottom_item
6	FROM stacks;