MIN function - Amazon Quantum Ledger Database (Amazon QLDB)

MIN function

Syntax

MIN ( expression )

Returns the minimum value in a set of documents.

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 MIN(r.PendingPenaltyTicketAmount) FROM VehicleRegistration r -- 30.45 SELECT MIN(a) FROM << { 'a' : 1 }, { 'a': 2 }, { 'a': 3 } >> -- 1

Related functions