Reference material for ARRAY_REVERSE function
Returns an array of the same size and type as the original array, with the elements in reverse order. Nulls are retained.
Parameter | Description | Supported input types |
---|---|---|
<array> | The array to be reversed | ARRAY of any type |
ARRAY
of the same type as the input array
The following example returns the reverse of the input array:
Returns: [6,3,2,1]
Only the outermost array is reversed for nested arrays:
Returns: [[8,9], [7], NULL, [4,5], [1,2,3]]