Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Summarizing, Grouping, and Sorting Query Results » Summarizing query results using aggregate functions

Using aggregate functions with DISTINCT Next Page

Aggregate functions and NULL

Any NULLS in the column on which the aggregate function is operating are ignored for the purposes of the function except COUNT(*), which includes them. If all the values in a column are NULL, COUNT(column_name) returns 0.

If no rows meet the conditions specified in the WHERE clause, COUNT returns a value of 0. The other functions all return NULL. Here are examples:

   FROM Products
   WHERE UnitPrice > 50;
count(DISTINCT Name)
SELECT AVG( UnitPrice )
   FROM Products
   WHERE UnitPrice > 50;
( NULL )