The SUM function returns the sum of a set of numbers.
The data type of the result is the same as the data type of the argument values except that the result is:
For information on the values of p, s, and mp, see Decimal arithmetic in SQL.
The function is applied to the set of values derived from the argument values by the elimination of null values. If DISTINCT is specified, duplicate values are eliminated.
The result can be null. If the function is applied to the empty set, the result is a null value. Otherwise, the result is the sum of the values in the set.
The order in which the values are added is undefined, but every intermediate result must be within the range of the result data type.
SELECT SUM(BONUS) INTO :JOB_BONUS FROM EMPLOYEE WHERE JOB = 'CLERK'Results in JOB_BONUS being set to 4000.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.