This section contains reference documentation for the DISTINCTAVG function.
Was this helpful?
Returns the average of distinct row values in a group
DISTINCTAVG(colName) or avg(distinct col)
These examples are based on the .
SELECT DISTINCTAVG(runs) AS VALUE FROM baseballStats
83.36526946107784
SELECT AVG(DISTINCT AtBatting) AS VALUE FROM baseballStats
349.1158798283262