sum

Returns the total of the values.

Syntax

sum([all | distinct] expression)

Parameters

Examples

Usage

  • sum, an aggregate function, finds the sum of all the values in a column. sum can only be used on numeric (integer, floating point, or money) datatypes. Null values are ignored in calculating sums.

  • When you sum integer data, the SAP ASE server treats the result as an int value, even if the datatype of the column is smallint or tinyint.When you sum bigint data, the SAP ASE server treats the result as a bigint.To avoid overflow errors in DB-Library programs, declare all variables for results of averages or sums appropriately.

  • You cannot use sum with the binary datatypes.

  • This function defines only numeric types; use with Unicode expressions generates an error.

See also:
  • compute clause, group by and having clauses, select, where clause in Reference Manual: Commands

  • Transact-SQL Users Guide

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute sum.

Related concepts
Expressions
Related reference
count
max
min