docs/sql-manual/sql-functions/scalar-functions/array-functions/array-reverse-sort.md

---
{
    "title": "ARRAY_REVERSE_SORT",
    "language": "en-US",
    "description": "Sort array elements in descending order."
}
---

## Function

Sort array elements in descending order.

## Syntax

- `ARRAY_REVERSE_SORT(arr)`

## Parameters

- `arr`: `ARRAY<T>`, where `T` can be numeric, boolean, string, datetime, IP, UUID, etc. Multi-dimensional arrays are supported, but all array elements (no matter how deeply nested) must be of the supported types.

## Return value

- Returns `ARRAY<T>` of the same type as the input.
- `NULL` elements are placed at the end of the returned array.

## Usage notes

- If the input is `NULL`, returns `NULL`; if the input is an empty array `[]`, returns an empty array.
- `ARRAY_REVERSE_SORT` sorts in descending order, while `ARRAY_SORT` sorts in ascending order.

## Examples

- Basic: `NULL` elements are placed at the end of the returned array
  - `ARRAY_REVERSE_SORT([1,2,3,null])` -> `[3,2,1,null]`

- If the input is `NULL`, returns `NULL`; if the input is an empty array `[]`, returns an empty array.
  - `ARRAY_REVERSE_SORT(NULL)` -> `NULL`
  - `ARRAY_REVERSE_SORT([])` -> `[]`

- Multi-dimensional array sort
  - `ARRAY_REVERSE_SORT([[3, 4], [5, 6]])` -> `[[5, 6], [3, 4]]`