AVG( [ DISTINCT ] numeric-expression )

Returns the NULL value for a group containing no rows.

Returns DOUBLE if the argument is DOUBLE, otherwise NUMERIC.

This average does not include rows where the numeric-expression is the NULL value.

This function can generate an overflow error, resulting in an error being returned. You can use the CAST function on numeric-expression to avoid the overflow error. See CAST function [Data type conversion].

• SUM function [Aggregate]
• COUNT function [Aggregate]

The following statement returns the value 49988.623200.

SELECT AVG( Salary ) FROM Employees;

The following statement returns the average product price from the Products table:

SELECT AVG( DISTINCT UnitPrice ) FROM Products;