MIN

Copyright © Cloud Software Group, Inc. All Rights Reserved

MIN

Returns the smaller of two given values. (F)

invocation

smaller = MIN(x, y)

smaller

The value returned, either x or y.

x

A value to be compared to y.

y

A value to be compared to x.

Usage Notes

The values passed to MIN must represent numbers, and can be any syntax.

Example

The following rule finds the lowest and highest paid employees by comparing each salary in the EMPLOYEE table.

SALARY_RANGE

_ LOCAL HIGHEST,LOWEST;

_ ---------------------------------------------------------------------

_ ------------------------------------------------------------+--------

_ LOWEST = 99999; | 1

_ FORALL EMPLOYEE: | 2

_ HIGHEST= MAX(HIGHEST,EMPLOYEE.SALARY); |

_ LOWEST = MIN(LOWEST,EMPLOYEE.SALARY); |

_ END; |

_ CALL MSGLOG('THE HIGHEST SALARY IS ' || HIGHEST); | 3

_ CALL MSGLOG('THE LOWEST SALARY IS ' || LOWEST); | 4

_ ---------------------------------------------------------------------

smaller	The value returned, either x or y.
x	A value to be compared to y.
y	A value to be compared to x.