Functions/Lists & arrays/array_reverse_sort
Lists & arrays Scalar

array_reverse_sort()

Sorts the elements of the list in reverse order.

Alias of list_reverse_sort()

Arguments & returns

2 overloads

array_reverse_sort(list)

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

array_reverse_sort(list, col1)

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

Example

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

Engine example · Run to view results.

In other engines

Apache Hivesort_array()

SELECT SORT_ARRAY(x, FALSE)
In Haybarn
SELECT ARRAY_REVERSE_SORT(x)

SQLGlot example ↗