Links

ARRAY_SORT_DESC

Returns the values sorted in descending order.

Syntax

ARRAY_SORT_DESC(array)

Arguments

array

Type: any
An array of any value types.

Returns

Type: same as input but in descending order.

Examples

array
Output
[2, 1, 3]
[3, 2, 1]
['b', 'a', 'cd', 'cc']
['cd', 'cc', 'b', 'a']
[0.5, 1.0, 0.75, 1.5]
[1.5, 1.0, 0.75, 0.5]
null::string
NULL
[true, false, true]
[true, true, false]
[date '2023-04-01', date '2023-04-01', date '2023-05-02']
[date '2023-05-02', date '2023-04-01', date '2023-04-01']
[timestamp '2023-01-02 11:00:00', timestamp '2023-01-01 09:00:00', timestamp '2023-01-01 10:00:00']
[timestamp '2023-01-02 11:00:00', timestamp '2023-01-01 10:00:00', timestamp '2023-01-01 09:00:00']
Last modified 4mo ago