arraySliceString
This section contains reference documentation for the arraySliceString function.
Returns the values in the array between the start and end positions.
arraySliceString('colName', start, end)
select FlightNum,
arraySliceString(RandomAirports, 0, 2) AS airports,
RandomAirports
from airlineStats
WHERE arraylength(RandomAirports) BETWEEN 2 AND 4
limit 5
FlightNum | airports | RandomAirports |
---|---|---|
671 | SEA,PSC | SEA,PSC,PHX,MSY |
1767 | SEA,PSC | SEA,PSC,PHX |
2522 | SEA,PSC | SEA,PSC |
424 | SEA,PSC | SEA,PSC,PHX,MSY |
3162 | SEA,PSC | SEA,PSC,PHX,MSY |
Last modified 1yr ago