SUM function
Returns the sum of the input field or expression values. The SUM function
works with numeric values and ignores null or missing values.
Syntax
SUM (expression)
Arguments
expression-
The field name or expression of a numeric data type that the function operates on.
Data types
Supported argument types:
-
int -
decimal -
float
Supported return types:
-
int– For integer arguments -
decimal– For decimal or floating point arguments
Examples
SELECT SUM(r.PendingPenaltyTicketAmount) FROM VehicleRegistration r -- 735.95 SELECT SUM(a) FROM << { 'a' : 1 }, { 'a': 2 }, { 'a': 3 } >> -- 6
Related functions
