Min, Max and Limit

MAX

MAX(x1, x2, …)

Returns the maximum of all parameters.

The function is overloaded for any integer and floatingpoint type. The smallest common type of all parameters is used as return type.

MIN

MIN(x1, x2, …)

Returns the minimum of all parameters.

The function is overloaded for any integer and floatingpoint type. The smallest common type of all parameters is used as return type.

LIMIT

LIMIT(min,in,max)

Returns in if it lies in the interval [min,max]. Otherwise, the violated bound (min or max) is returned.

The function is overloaded for any integer and floatingpoint type. The smallest common type of all parameters is used as return type.

Min, Max and Limit 1:

CONSTRAINT:

The min boundary must be smaller than the max boundary.