Difference between revisions of "MAX()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (MAX() moved to SQL MAX()) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | ==Class== | |
| + | Numeric Data | ||
| + | |||
| + | |||
| + | ==Purpose== | ||
| + | Function to return maximum value function | ||
| + | |||
| + | |||
| + | ==Syntax== | ||
| + | MAX(<exp1>,<exp2>) | ||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | [[AMAX()]], [[AMIN()]], [[IIF()]], [[MIN()]], [[MOD()]] | ||
| + | |||
| + | |||
| + | ==Description== | ||
| + | The MAX() function returns the greater of the two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types. | ||
| + | |||
| + | |||
| + | ==Example== | ||
| + | <code lang="recital"> | ||
| + | ? max(1, 3) | ||
| + | 3 | ||
| + | set date british | ||
| + | ? max(ctod("15/10/1997"), ctod("14/10/1997")) | ||
| + | 15/10/1997 | ||
| + | </code> | ||
| + | |||
| + | |||
| + | ==Products== | ||
| + | Recital Database Server, Recital Mirage Server, Recital Terminal Developer | ||
| + | [[Category:Documentation]] | ||
| + | [[Category:Functions]] | ||
Revision as of 11:48, 23 March 2009
Class
Numeric Data
Purpose
Function to return maximum value function
Syntax
MAX(<exp1>,<exp2>)
See Also
AMAX(), AMIN(), IIF(), MIN(), MOD()
Description
The MAX() function returns the greater of the two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types.
Example
? max(1, 3) 3 set date british ? max(ctod("15/10/1997"), ctod("14/10/1997")) 15/10/1997
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
