AVG

Given a set of numeric values, AVG calculates and returns the average of the input values, as FLOAT, DECIMAL, or NULL.

Syntax

AVG (expression)

Remarks

The expression is a numeric expression.
AVG works only with numeric data types.
If you want to exclude a specific row from the calculation of the average, make any column value in the row NULL.
See About SQL Functions in TDV for an explanation of the DECIMAL(p,s) notation.

The following table lists the input types and their corresponding output types.

Data Type of expression

Output Type

BIGINT, DOUBLE, FLOAT, INTEGER, INTERVAL_DAY, INTERVAL_YEAR, REAL, SMALLINT, TINYINT

Same type as that of the input. For example, if the input is of type TINYINT, the output is also of type TINYINT.

DECIMAL(p,s)
NUMERIC(p,s)

DECIMAL(p,s)

VARCHAR

DECIMAL(p,s)
Runtime exception if expression cannot be converted to a numeric value.

NULL

NULL

Example

SELECT AVG (UnitPrice) Price, ProductID
FROM /shared/examples/ds_inventory/products products
GROUP BY ProductID