Powered by GitBook

1 of 1

Loading...

arraySortString

This section contains reference documentation for the arraySortString function.

Sorts array of strings.

Signature

arraySortString('colName')

Usage Examples

These examples are based on the .

FlightNum

sortedAirports

RandomAirports

429

MSY,PHX,PSC,SEA

SEA,PSC,PHX,MSY

1206

PSC,SEA

SEA,PSC

5300

PSC,SEA

SEA,PSC

3846

PSC,SEA

SEA,PSC

3635

MSY,PHX,PSC,SEA

SEA,PSC,PHX,MSY

Hybrid Quick Start

select FlightNum, 
       arraySortString(RandomAirports) AS sortedAirports, 
       RandomAirports
from airlineStats 
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5