1 of 1

DISTINCTAVGMV

This section contains reference documentation for the DISTINCTAVGMV function.

Returns the average of distinct row values in a group

Signature

DISTINCTAVGMV(colName)

These examples are based on the Hybrid Quick Start.

SELECT DISTINCTAVGMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1

VALUE

This section contains reference documentation for the DISTINCTAVGMV function.

Returns the average of distinct row values in a group

DISTINCTAVGMV(colName)

These examples are based on the Hybrid Quick Start.

SELECT DISTINCTAVGMV(DivLongestGTimes) AS VALUE
FROM airlineStats
WHERE arraylength(DivLongestGTimes) > 1

VALUE