This section contains reference documentation for the DISTINCTCOUNT function.
Was this helpful?
Returns the count of distinct row values in a group
DISTINCTCOUNT(colName)
These examples are based on the .
select DISTINCTCOUNT(league) AS value from baseballStats
7
select DISTINCTCOUNT(teamID) AS value from baseballStats
149