DISTINCTCOUNT
This section contains reference documentation for the DISTINCTCOUNT function.
Returns the count of distinct row values in a group
DISTINCTCOUNT(colName)
select DISTINCTCOUNT(league) AS value
from baseballStats
value |
---|
7 |
select DISTINCTCOUNT(teamID) AS value
from baseballStats
value |
---|
149 |
Last modified 1yr ago