AVG

Returns the average value of an expression.

Syntax

See Oracle Database SQL Language Reference.

Restrictions

The following restrictions apply when you use the AVG function in the SELECT command:

• The expression must be a numeric column or a positive numeric constant.

• The function does not support the DISTINCT or ALL keywords.

• The function does not support the OVER clause.