Difference between revisions of "MIN()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (MIN() moved to SQL MIN()) |
Helengeorge (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ==Purpose== | |
| + | Function to return the minimum value | ||
| + | |||
| + | |||
| + | ==Syntax== | ||
| + | MIN(<exp1>, <exp2>) | ||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | [[AMAX()]], [[AMIN()]], [[IIF()]], [[MAX()]], [[MOD()]] | ||
| + | |||
| + | |||
| + | ==Description== | ||
| + | The MIN() function returns the lesser of two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types. | ||
| + | |||
| + | |||
| + | ==Example== | ||
| + | <code lang="recital"> | ||
| + | ? min(1, 3) | ||
| + | 1 | ||
| + | ? min(ctod("01/02/1997"), date()) | ||
| + | 01/02/1997 | ||
| + | </code> | ||
| + | |||
| + | |||
| + | ==Products== | ||
| + | Recital Server, Recital | ||
| + | [[Category:Documentation]] | ||
| + | [[Category:Functions]] | ||
| + | [[Category:Numeric Data]] | ||
| + | [[Category:Numeric Data Functions]] | ||
Latest revision as of 17:09, 3 December 2009
Purpose
Function to return the minimum value
Syntax
MIN(<exp1>, <exp2>)
See Also
AMAX(), AMIN(), IIF(), MAX(), MOD()
Description
The MIN() function returns the lesser of two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types.
Example
? min(1, 3) 1 ? min(ctod("01/02/1997"), date()) 01/02/1997
Products
Recital Server, Recital
