arrayReverseString
This section contains reference documentation for the arrayReverseString function.
Reverses array of strings.
arrayReverseString('colName')
select FlightNum,
arrayReverseString(RandomAirports) AS reversedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5
FlightNum | reversedAirports | RandomAirports |
|---|---|---|
1206 | PSC,SEA | SEA,PSC |
5300 | PSC,SEA | SEA,PSC |
3359 | MSY,PHX,PSC,SEA | SEA,PSC,PHX,MSY |
1023 | PHX,PSC,SEA | SEA,PSC,PHX |
963 | MSY,PHX,PSC,SEA | SEA,PSC,PHX,MSY |
Last modified 1yr ago