DISTINCTSUM

This section contains reference documentation for the DISTINCTSUM function.

Returns the sum of distinct row values in a group

Signature

DISTINCTSUM(colName) or sum(distinct col)

Usage Examples

These examples are based on the Batch Quick Start.

SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStats

SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats