Array

LIST_SORT

DuckDB

Mengurutkan elemen dalam list. Support ascending/descending dan kontrol posisi NULL.

Tipe hasil: LISTDiperbarui: 6 Jan 2026

Syntax

SQL

LIST_SORT(list) | LIST_SORT(list, 'ASC'|'DESC') | LIST_SORT(list, order, nulls_position)

listLISTwajib

List yang akan diurutkan

orderVARCHARopsional

'ASC' (default) atau 'DESC'

Default: ASC

nulls_positionVARCHARopsional

'NULLS FIRST' atau 'NULLS LAST'

Default: NULLS LAST

SQL

1 SELECT LIST_SORT([3, 1, 4, 1, 5, 9, 2, 6]) AS sorted;

Mengurutkan angka ascending (default).

Hasil

[1, 1, 2, 3, 4, 5, 6, 9]

SQL

1 SELECT LIST_SORT([3, 1, 4, 1, 5], 'DESC') AS sorted;

Mengurutkan descending.

Hasil

[5, 4, 3, 1, 1]

SQL

1 SELECT
2   LIST_SORT([3, NULL, 1, NULL, 2]) AS nulls_last,
3   LIST_SORT([3, NULL, 1, NULL, 2], 'ASC', 'NULLS FIRST') AS nulls_first;

Kontrol posisi NULL.

Hasil

[1, 2, 3, NULL, NULL] | [NULL, NULL, 1, 2, 3]

SQL

1 SELECT LIST_SORT(['banana', 'apple', 'cherry', 'date']) AS sorted;

Sort string secara alphabetical.

Hasil

['apple', 'banana', 'cherry', 'date']

ARRAY_SORT

Snowflake

1	SELECT
2	LIST_SORT([3, NULL, 1, NULL, 2]) AS nulls_last,
3	LIST_SORT([3, NULL, 1, NULL, 2], 'ASC', 'NULLS FIRST') AS nulls_first;