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

SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats

Last updated