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)
Usage Examples
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
​

VALUE
83.36526946107784

VALUE
349.1158798283262

DISTINCT

DISTINCTAVGMV

Last modified 8mo ago