Powered by GitBook

1 of 1

Loading...

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 .

VALUE

VALUE

SELECT DISTINCTAVG(runs) AS VALUE
FROM baseballStats

83.36526946107784

349.1158798283262

Batch Quick Start

SELECT AVG(DISTINCT AtBatting) AS VALUE
FROM baseballStats