1 of 1

DISTINCTCOUNT

This section contains reference documentation for the DISTINCTCOUNT function.

Returns the count of distinct row values in a group

Signature

DISTINCTCOUNT(colName)

These examples are based on the Batch Quick Start.

select DISTINCTCOUNT(league) AS value
from baseballStats

value

select DISTINCTCOUNT(teamID) AS value
from baseballStats

value

This section contains reference documentation for the DISTINCTCOUNT function.

Returns the count of distinct row values in a group

DISTINCTCOUNT(colName)

These examples are based on the Batch Quick Start.

select DISTINCTCOUNT(league) AS value
from baseballStats

value

select DISTINCTCOUNT(teamID) AS value
from baseballStats

value