Returns the minimum value of a series of values.
Category: | Mathematical |
Returned data type: | Real |
MIN(argument1 <, argument2, …>)
argument1
specifies a value that has a data type of real; 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 = 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