Navigation:  MCL Reference > Arithmetic Functions >

Minimum( )

Print this Topic Previous pageReturn to chapter overviewNext page

The Minimum( ) function returns the minimum of a set of values. Null values inside the set will be ignored. You may pass up to 27 arguments into the function.




x1, x2, x3,... must be of the same data type.



Value returned by the function will be of the same type and width of the referencing column.



Minimum(Column('This Rating'),Column('Last Rating'))

The minimum of the columns This Rating and Last Rating will be returned.


Minimum(123, .NULL., 234)

123 will be returned by the above function. .NULL. is ignored.


Minimum('A+', 'B')

'A+' will be returned by the above function. A+ is smaller than B in alphabetical order.



Page url: