MAX
(Function)
Extracts the maximum value.
MAX (<Expression>,<Expression>[,<Expression>...])
This statement extracts the maximum value from an arbitrary number of <Expression>'s.
The maximum 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 = MAX(1, 2)
|
'Assigns the maximum value between (1, 2) to
'li1.
|
|
li2 = MAX(li3, li4, li5, li6)
|
'Assigns the maximum value among (li3, li4,
'li5, li6) to li2.
|
|
lf1 = MAX(lf2, lf3, lf4, lf5, lf6)
|
'Assigns the maximum value among (lf2, lf3,
'lf4, lf5, lf6) to lf1.
|