Powered by GitBook

1 of 1

Loading...

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 .

VALUE

VALUE

SELECT DISTINCTSUM(runs) AS VALUE
FROM baseballStats

13922

SELECT SUM(DISTINCT AtBatting) AS VALUE
FROM baseballStats

244032

Batch Quick Start