SUMMARY
There are distinct differences between the MIN() and MAX() functions and
the SELECT-SQL MIN() and MAX() field functions. The SELECT-SQL MIN() and
MAX() field functions accept only one argument, whereas the MIN() and MAX()
functions accept multiple arguments.
The following examples demonstrate how each function would be used in a
FoxPro program.
SELECT MIN(price) from detail
&& This statement will select the record with lowest price
&& in the database.
SELECT MIN(IIF(price < 0,0,price)) FROM detail
&& This statement will select the record with the lowest price
&& as long as it is not less than zero; if it is less than zero,
&& it will return zero (0).
?MIN(54, 39, 40)
&& This statement will return the minimum of the three parameters
&& (39).
?MAX(54, 39, 40)
&& This statement will return the maximum of the three parameters
&& (54).
SELECT MIN(price,0) from detail
&& This statement will cause the error " MISSING ) " to occur.
&& To correct this statement, remove the second argument from
&& the MIN() function, as shown in the first example.
For Visual FoxPro 6.0 and later versions, use this code:
open database home(2)+"data\testdata.dbc"
SELECT MIN(order_amt) from orders
&& This statement will select the record with lowest price
&& in the database.
SELECT MIN(IIF(order_amt < 0,0,order_amt)) FROM orders
&& This statement will select the record with the lowest price
&& as long as it is not less than zero; if it is less than zero,
&& it will return zero (0).
?MIN(54, 39, 40)
&& This statement will return the minimum of the three parameters
&& (39).
?MAX(54, 39, 40)
&& This statement will return the maximum of the three parameters
&& (54).
SELECT MIN(order_amt,0) from orders
&& This statement will cause the error " MISSING ) " to occur.
&& To correct this statement, remove the second argument from
&& the MIN() function, as shown in the first example.