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
VALUE
13922
​
SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats
VALUE
244032

VALUE
13922

VALUE
244032

DISTINCTCOUNTTHETASKETCH

DISTINCTSUMMV

Last modified 2mo ago