sum

Description

Calculate the sum of the argument across the group, or of the scalar arguments if more than one. In the case of the scalar arguments, the function evaluates to null if any of the arugments evaluate to null.

Return type

numeric or duration

Domain

This is an aggregate function (aggregates rows over a group in aggregate verbs.)

This is a window function (calculates over a group of multiple input rows using windowing.)

Categories

• Aggregate

• Time

• Window

Usage

sum( value ... )

Argument	Type	Required	Multiple	Constant
value	numeric or duration	Required	Can be multiple	Variable