MIN
(Function)
Extracts the minimum value.
MIN (<Expression>,<Expression>[,<Expression>...])
This statement extracts the minimum value from an arbitrary number of <Expression>'s.
The minimum number of expressions is 32.
If the MIN function and the MAX function are used, the minimum or maximum value of the designated accumulation method or group fields can be obtained. For example, this function can be used to check the maximum and minimum shipping charges. If there is no designation of the accumulation method, the whole table becomes an object.
|
DEFSNG lf1, lf2, lf3, lf4, lf5, lf6
|
|
|
DEFINT li1, li2, li3, li4, li5, li6
|
|
|
li1 = MIN(1, 2)
|
'Assigns the minimum value between (1, 2) to li1.
|
|
li2 = MIN(li3, li4, li5, li6)
|
'Assigns the minimum value among (li3, li4,
'li5, li6) to li2.
|
|
lf1 = MIN(lf2, lf3, lf4, lf5, lf6)
|
'Assigns the minimum value among (lf2, lf3,
'lf4, lf5, lf6) to lf1.
|