DISTINCTCOUNTMV
This section contains reference documentation for the DISTINCTCOUNTMV function.
Returns the count of distinct row values in a group
Signature
DISTINCTCOUNTMV(colName)
Usage Examples
These examples are based on the Hybrid Quick Start.
The following query returns the documents that have a DivTailNums
with more than one value:
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:
value
2