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 arugments evaluate to null
.
Return type¶
float or duration
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 ... )
Argument |
Type |
Required |
Multiple |
Constant |
---|---|---|---|---|
value |
numeric or duration |
Required |
Can be multiple |
Variable |