AVG Function | Average | Teradata Vantage - 17.10 - AVG - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.