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
Was this helpful?