MIN Function

Purpose

Returns the smallest of one or more values.

Syntax

MIN(x,...)

Parameters

x and any subsequent values are arithmetic values.

Description

The MIN function returns the smallest of a set of arithmetic values. x and any subsequent values are converted to a common arithmetic data type (using the conversion rules for arithmetic infix operators) before the operation is performed. x and any subsequent values cannot be string values. The result is the smallest of these converted values and has the common arithmetic data type. The maximum number of arguments is 64.

Examples

MIN(5,-118, 1)         /* returns -118 */
MIN(12.3, 11, 9.68)    /* returns 9.68 */

Restrictions

None.