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.

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

• Troubleshooting: Aggregate functions and outer references

The following statement returns the value 49988.623200 when connected to the SQL Anywhere 16 Demo:

SELECT AVG( Salary ) FROM Employees;

The following statement returns the average product price from the Products table when connected to the SQL Anywhere 16 Demo:

SELECT AVG( DISTINCT UnitPrice ) FROM Products;