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. ().
Sample Source Pattern
Syntax
SUM ( [ ALL | DISTINCT ] expression )
SUM( [ DISTINCT ] <expr1> )
Examples
Code:
IN -> SqlServer_01.sql
SELECT SUM(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS TOTALVACATIONHOURS;
Result:
TOTALVACATIONHOURS|
------------------+
14678|
Code:
OUT -> SqlServer_01.sql
SELECT
SUM(VACATIONHOURS) FROM
HUMANRESOURCES.EMPLOYEE AS TOTALVACATIONHOURS;