avg

Returns the average of non-NULL records. If all records inside a group are NULL, the function returns NULL.

Syntax

avg( <expr> )

Arguments

<expr>

This is an expression that evaluates to a numeric data type.