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

PreviousDISTINCTCOUNTTHETASKETCHNextDISTINCTSUMMV