arraySortString
This section contains reference documentation for the arraySortString function.
Sorts array of strings.
arraySortString('colName')
select FlightNum,
arraySortString(RandomAirports) AS sortedAirports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5
FlightNum | sortedAirports | RandomAirports |
|---|---|---|
3846 | PSC,SEA | SEA,PSC |
3635 | MSY,PHX,PSC,SEA | SEA,PSC,PHX,MSY |
429 | MSY,PHX,PSC,SEA | SEA,PSC,PHX,MSY |
1206 | PSC,SEA | SEA,PSC |
5300 | PSC,SEA | SEA,PSC |
Last modified 1yr ago