Link Search Menu Expand Document

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

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

Example

SELECT
	ARRAY_REVERSE_SORT([ 4, 1, 3, 2 ]);

Returns: [4,3,2,1]

In this example below, 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.

SELECT
	ARRAY_REVERSE_SORT(x -> x % 2, [ 4, 1, 3, 2 ]);

Returns: [1,3,4,2]