Functions/Lists & arrays/array_sort
Lists & arrays Scalar

array_sort()

Sorts the elements of the list.

Alias of list_sort()

Arguments & returns

3 overloads

array_sort(list)

Scalar
Overload link list Returns
#01 ANY[] ANY[]

array_sort(list, col1)

Scalar
Overload link listcol1 Returns
#02 ANY[]VARCHAR ANY[]

array_sort(list, col1, col2)

Scalar
Overload link listcol1col2 Returns
#03 ANY[]VARCHARVARCHAR ANY[]

Example

array_sort example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Apache Sparkarray_sort()

Same function

Prestoarray_sort()

SELECT ARRAY_SORT(x, (left, right) -> -1)
In Haybarn
SELECT ARRAY_SORT(x)

SQLGlot example ↗