MIN Function

Returns the minimum value of a series of values.

Category: Mathematical
Returned data type: Real

Syntax

MIN(argument1 <, argument2, …>)

Required Argument

argument1

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

Optional Arguments

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 = min(1, 3, -2) // outputs -2

x = min(1, null, 3) // outputs 1

x = min(-3) // outputs -3

x = min(4, -3*1.5) // outputs -4.5