ASA SQL Reference

SQL Functions

Alphabetical list of functions

SUM function [Aggregate]

Function 

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

Syntax 

SUM ( expression | DISTINCT column-name )

Parameters 

expression    The object to be summed. This is commonly a column name.

DISTINCT column-name    This is of limited usefulness, but is included for completeness.

Usage 

Rows where the specified expression is NULL are not included.

Returns NULL for a group containing no rows.

Standards and compatibility 

• SQL/92    SQL/92 compatible.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

• COUNT function [Aggregate]
• AVG function [Aggregate]

Example 

The following statement returns the value 3749146.

SELECT SUM( salary )
FROM Employee

SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.