Returns the maximum value of a series of values.
Category: | Mathematical |
Returned data type: | Real |
MAX(argument1 <, argument2, …>)
argument1
specifies a value that has a real data type; this can be specified as a numeric constant, field name, or expression
argument2, ...
specifies one or more values that have a real data type; these can be specified as a numeric constant, field name, or expression
The function returns null if all values are null.
x = max(1, 3, -2)
// outputs 3
x = max(1, null, 3)
// outputs 3
x = max(-3)
// outputs -3
x = max(4, -3*1.5)
// outputs 4