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.
CONSTRAINT: The |