Skip to content

Latest commit

 

History

History
32 lines (24 loc) · 665 Bytes

arraydistinctstring.md

File metadata and controls

32 lines (24 loc) · 665 Bytes
description
This section contains reference documentation for the arrayDistinctString function.

arrayDistinctString

Returns unique values in an array of strings.

Signature

arrayDistinctString('colName')

Usage Examples

These examples are based on the Hybrid Quick Start.

select DivTailNums, 
       arrayDistinctString(DivTailNums) AS unique
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5
DivTailNums unique
N7713A,N7713A N7713A
N344AA,N344AA N344AA
N344AA,N344AA N344AA
N7713A,N7713A N7713A