> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for ARRAY_REVERSE_SORT function

# ARRAY_REVERSE_SORT

Returns the elements of the input array in descending order.

If the argument `<function>` is provided, the sorting order is determined by the result of applying `<function>` on each element of the array.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
ARRAY_REVERSE_SORT([<function>,] <array>)
```

## Parameters

| Parameter    | Description                                                  | Supported input type                                              |
| :----------- | :----------------------------------------------------------- | :---------------------------------------------------------------- |
| `<function>` | An optional function to be used to determine the sort order. | Any lambda function that takes the elements of `<array>` as input |
| `<array>`    | The array to be sorted.                                      | Any array                                                         |

## Return Type

`ARRAY` of the same type as the input array

## Examples

<div className="query-window">
  ```
  SELECT ARRAY_REVERSE_SORT([4, 1, 3, 2]);
  ```

  | array\_reverse\_sort <span>array(int)</span> |
  | :------------------------------------------- |
  | \[4, 3, 2, 1]                                |

  <p><span>Rows: 1</span><span>Execution time: 6.25ms</span></p>
</div>

In this example, the modulus operator is used to calculate the remainder on any odd numbers. Therefore `ARRAY_REVERSE_SORT` puts the lower (even) numbers last in the results.

<div className="query-window">
  ```
  SELECT ARRAY_REVERSE_SORT(x -> x % 2, [4, 1, 3, 2]);
  ```

  | array\_reverse\_sort <span>array(int)</span> |
  | :------------------------------------------- |
  | \[1, 3, 4, 2]                                |

  <p><span>Rows: 1</span><span>Execution time: 6.64ms</span></p>
</div>