DISTINCTCOUNTMV
This section contains reference documentation for the DISTINCTCOUNTMV function.
Returns the count of distinct row values in a group
DISTINCTCOUNTMV(colName)
The following query returns the documents that have a
DivTailNums
with more than one value:select DivTailNums
from airlineStats
where arraylength(DivTailNums) > 1
DivTailNums |
---|
N7713A,N7713A |
N344AA,N344AA |
N344AA,N344AA |
N7713A,N7713A |
You can count the distinct number of items in these rows by running the following query:
select DISTINCTCOUNTMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1
value |
---|
2 |
Last modified 1yr ago