MAX function - Amazon Quantum Ledger Database (Amazon QLDB)

MAX function

Returns the maximum value in a set of documents.

Syntax

MAX ( 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

  • decimal

  • float

Examples

SELECT MAX(r.PendingPenaltyTicketAmount) FROM VehicleRegistration r -- 442.30 SELECT MAX(a) FROM << { 'a' : 1 }, { 'a': 2 }, { 'a': 3 } >> -- 3

Related functions