Lists & arrays Scalar

list_sort()

Sorts the elements of the list.

Arguments & returns

3 overloads

Scalar

Overload link	`list`	Returns
#01	`ANY[]`	`ANY[]`

Scalar

Overload link	`list`	`col1`	Returns
#02	`ANY[]`	`VARCHAR`	`ANY[]`

Scalar

Overload link	`list`	`col1`	`col2`	Returns
#03	`ANY[]`	`VARCHAR`	`VARCHAR`	`ANY[]`

SELECT list_sort([3, 6, 1, 2]);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT ARRAY_SORT(x)

In Haybarn

SELECT LIST_SORT(x)