Link Search Menu Expand Document

ARRAY_SORT

Returns the elements of <arr> in ascending order.

If the argument <func> is provided, the sorting order is determined by the result of applying <func> on each element of <arr>.

Syntax

ARRAY_SORT([<func>,] <arr>)
Parameter Description
<func> An optional function to be used to determine the sort order.
<arr> The array to be sorted.

Example

SELECT
	ARRAY_SORT([ 4, 1, 3, 2 ]) AS res;

Returns: 1,2,3,4

In this example below, the modulus operator is used to calculate the remainder on any odd numbers. Therefore ARRAY_ SORT puts the higher (odd) numbers last in the results.

SELECT
	ARRAY_SORT(x -> x % 2, [ 4, 1, 3, 2 ]) AS res;

Returns: 4,2,1,3