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.
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