Loading...
This section contains reference documentation for the DISTINCTSUM function.
Returns the sum of distinct row values in a group
DISTINCTSUM(colName) or sum(distinct col)
These examples are based on the Batch Quick Start.
SELECT DISTINCTSUM(runs) AS VALUE FROM baseballStats
13922
SELECT SUM(DISTINCT AtBatting) AS VALUE FROM baseballStats
244032