ARRAY_REVERSE

All functions > ARRAY > ARRAY_REVERSE

Returns the reverse of an array.

Syntax

ARRAY_REVERSE(array)
sql

Arguments

ParameterTypeRequiredDescription
arrayARRAYBIGINTYesThe input array to reverse

Returns

An array with elements in reverse order

Notes

  • Reverses the order of elements in the input array
  • Returns a new array where the first element becomes the last
  • The original array is not modified
  • Works with any array type (numbers, strings, etc.)

Examples

Last update at: 2025/10/13 10:23:46