avg

Description

Calculate the arithmetic average of the input expression across the group, or of the scalar arguments if more than one. In the case of the scalar arguments, the function evaluates to null if any of the arguments evaluate to null.

Return type

value

Domain

This is an aggregate function (aggregates rows over a group in aggregate verbs.)

This is a window function (calculates over a group of multiple input rows using windowing.)

Categories

Usage

avg(value_1, value_2, ...)

Argument

Type

Optional

Repeatable

Restrictions

value

numeric or duration

no

yes

none