Returns the arithmetic average of all values in value_expression.
AVG is valid only for numeric data.
Nulls are not included in the result computation.
This function returns the REAL data type.
To invoke the time series version of this function, use the GROUP BY TIME clause. For more information, see Teradata Vantage™ - Time Series Tables and Operations, B035-1208.
For the AVG window function that computes a group, cumulative, or moving average, see Window Aggregate Functions.
ANSI Compliance
This statement is ANSI SQL:2011 compliant.
AVERAGE and AVE are Teradata extensions to the ANSI standard.