array_reverse_sort()

Sorts the elements of the list in reverse order.

Reference: DuckDB 1.4.4

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 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

Apache Hivesort_array()

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

SQLGlot example ↗