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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (P-Z)

 

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.

Returns

INTEGER

DOUBLE

NUMERIC

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;