Skip to content

Latest commit

 

History

History
36 lines (23 loc) · 623 Bytes

distinctavg.md

File metadata and controls

36 lines (23 loc) · 623 Bytes
description
This section contains reference documentation for the DISTINCTAVG function.

DISTINCTAVG

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