MAX Function

Returns the maximum value of a series of values.

Category: Mathematical
Returned data type: Real

Syntax

MAX(argument1< , argument2, ...>)

Required Argument

argument1

specifies a value that has a real data type; this can be specified as a numeric constant, field name, or expression.

Optional Argument

argument2, ...

specifies one or more values that have a real data type; these can be specified as a numeric constant, field name, or expression.

Details

The function returns NULL if all values are NULL.

Example

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