Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the total of the specified expression for each group of rows.
SUM( expression | DISTINCT expression )
expression The object to be summed. This is commonly a column name.
DISTINCT expression Computes the sum of the unique values of expression in the input.
Rows where the specified expression is NULL are not included.
Returns NULL for a group containing no rows.
SQL/2003 Core feature.
The following statement returns the value 3749146.740.
SELECT SUM( Salary ) FROM Employees;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|