AVG Function | Average | VantageCloud Lake - AVG - Teradata VantageCloud Lake

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 Time Series Tables and Operations, B035-1208.

For the AVG window function that computes a group, cumulative, or moving average, see Window Aggregate Functions.

• AVG Function Syntax
• AVG Usage Notes
• Example: Using the AVG Function
• AVG Related Information

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

AVERAGE and AVE are Teradata extensions to the ANSI standard.