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

SQL Server

SUM ( [ ALL | DISTINCT ] expression )  

Snowflake SQL

Snowflake SQL Documentation

SUM( [ DISTINCT ] <expr1> )

Examples

SQL Server

Code:

SELECT SUM(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS TOTALVACATIONHOURS;

Result:

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

Snowflake SQL

Code:

SELECT SUM(VACATIONHOURS) FROM HUMANRESOURCES.EMPLOYEE AS TOTALVACATIONHOURS;

Result:

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