General-Purpose Aggregate Functions

General-purpose Aggregate Functions

Average

Result type

Depends on the input type

Syntax

AVG ([ALL | DISTINCT] <expr>)

Table 1. `AVG` Function Parameters
Parameter	Description
expr	Expression.It may contain a table column, a constant, a variable, an expression, a non-aggregate function or a UDF that returns a numeric data type.Aggregate functions are not allowed as expressions

AVG returns the average argument value in the group.NULL is ignored.

Parameter ALL (the default) applies the aggregate function to all values.
Parameter DISTINCT directs the AVG function to consider only one instance of each unique value, no matter how many times this value occurs.
If the set of retrieved records is empty or contains only NULL, the result will be NULL.

The result type of AVG depends on the input type:

FLOAT, DOUBLE PRECISION

DOUBLE PRECISION

SMALLINT, INTEGER, BIGINT

BIGINT

INT128

DECIMAL/NUMERIC(p, n) with p < 19

DECIMAL/NUMERIC(18, n)

DECIMAL/NUMERIC(p, n) with p >= 19

DECIMAL/NUMERIC(38, n)

DECFLOAT(16)

DECFLOAT(34)