AVG

AVG

Compute the mean of the the column/group/window. Supported on all numeric types.

Note

When used as a window function with an ORDER BY clause but no window frame, ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW is used by default.