SUM

Some parts in the output code are omitted for clarity reasons.

Description

Returns the sum of all the values, or only the DISTINCT values, in the expression. SUM can be used with numeric columns only. Null values are ignored. (SUM in Transact-SQL).

Sample Source Pattern

Syntax

SUM ( [ ALL | DISTINCT ] expression )  

Examples

Code:

IN -> SqlServer_01.sql
SELECT SUM(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS TOTALVACATIONHOURS;

Result:

TOTALVACATIONHOURS|
------------------+
             14678|

Known Issues

No issues were found.

No related EWIs.

Last updated