DISTINCTCOUNT

This section contains reference documentation for the DISTINCTCOUNT function.

Returns the count of distinct row values in a group
Signature
DISTINCTCOUNT(colName)
Usage Examples
These examples are based on the Batch Quick Start.
select DISTINCTCOUNT(league) AS value
from baseballStats 
value
7
select DISTINCTCOUNT(teamID) AS value
from baseballStats 
value
149

value
7

value
149

DISTINCTAVGMV

DISTINCTCOUNTBITMAP

Last modified 1yr ago