SUM function - Amazon Quantum Ledger Database (Amazon QLDB)

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