1 of 1

DISTINCTAVG

This section contains reference documentation for the DISTINCTAVG function.

Returns the average of distinct row values in a group

Signature

DISTINCTAVG(colName) or avg(distinct col)

These examples are based on the Batch Quick Start.

SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats

VALUE

83.36526946107784

SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats

VALUE

349.1158798283262

This section contains reference documentation for the DISTINCTAVG function.

Returns the average of distinct row values in a group

DISTINCTAVG(colName) or avg(distinct col)

These examples are based on the Batch Quick Start.

SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats

VALUE

83.36526946107784

SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats

VALUE

349.1158798283262