SUM
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:
SELECT SUM(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS TOTALVACATIONHOURS;
Result:
TOTALVACATIONHOURS|
------------------+
14678|
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated