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 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 = 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