| description |
|---|
This section contains reference documentation for the COUNTMV function. |
Get the count of rows in a group
COUNTMV(colName)
These examples are based on the Hybrid Quick Start.
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 number of items in these rows by running the following query:
select COUNTMV(DivTailNums) AS value
from airlineStats
where arraylength(DivTailNums) > 1| value |
|---|
| 8 |