All pages
Powered by GitBook
1 of 1

Loading...

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 .

value
value
select DISTINCTCOUNT(league) AS value
from baseballStats 

7

select DISTINCTCOUNT(teamID) AS value
from baseballStats 

149

Batch Quick Start