AVG
Calculates the average of an expression.
Syntax
AVG(<expr>)
| Parameter | Description |
|---|---|
<expr> | The expression used to calculate the average. Valid values for the expression include column names or functions that return a column name for columns that contain numeric values. |
The AVG() aggregation function ignores rows with NULL. For example, an AVG from 3 rows containing 1, 2, and NULL returns 1.5 because the NULL row is not counted. To calculate an average that includes NULL, use SUM(COLUMN)/COUNT(*).