DISTINCTAVG
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)
SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats
VALUE |
---|
83.36526946107784 |
SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats
VALUE |
---|
349.1158798283262 |
Last modified 8mo ago