Was this helpful?
Returns unique values in an array of strings.
arrayDistinctString('colName')
These examples are based on the .
This section contains reference documentation for the arrayDistinctString function.
select DivTailNums, arrayDistinctString(DivTailNums) AS unique from airlineStats WHERE arraylength(DivTailNums) >= 2 limit 5
N7713A,N7713A
N7713A
N344AA,N344AA
N344AA