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