1 of 1

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)

These examples are based on the Batch Quick Start.

SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStats

VALUE

SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats

VALUE

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

SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats

VALUE