minof()

Scalar. Returns the minimum value from a list of expressions.

Syntax

minof ( expression [,...] )

Parameters

expression

There must be at least one argument, and all the arguments must be of the same datatype.

Usage

Returns the minimum value from a list of expressions. NULL values are ignored. If all of the arguments are NULL, the function returns NULL. The arguments can be of any datatype, but they must be of the same datatype. The function returns the same datatype as its arguments.

Example

min ( 0.61, NULL, 2.34, 1.32) returns 0.61.