SUM function [Aggregate]

Returns the total of the specified expression for each group of rows.

Syntax 1 
SUM( expression | DISTINCT expression )
Parameters

  • 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.

Remarks

Rows where the specified expression is NULL are not included.

Returns NULL for a group containing no rows.

See also
Standards and compatibility

  • SQL/2003   Core feature.

Example

The following statement returns the value 3749146.740.

SELECT SUM( Salary )
FROM Employees;
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0