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
