Was this helpful?
Returns the values in the array between the start and end positions.
arraySliceInt('colName', start, end)
These examples are based on the .
This section contains reference documentation for the arraySliceInt function.
select FlightNum, arraySliceInt(DivAirportIDs, 0, 1) AS airports, DivAirportIDs from airlineStats WHERE arraylength(DivAirportIDs) >= 2 limit 5
1531
13891
13891,12892
19
14683
14683,14683
829
12339
12339,12339
24
13198
13198,10721
548
10721
10721,12478