Difference between revisions of "SQL MAX()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
|||
Line 26: | Line 26: | ||
[[Category:SQL|MAX()]] | [[Category:SQL|MAX()]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:SQL Functions]] |
Revision as of 03:34, 7 December 2012
Contents
Purpose
Returns a maximum value in a SELECT statement
Syntax
MAX(<expr>)
See Also
AGGREGATES, AVG(), COUNT(), MIN(), SELECT, SUM()
Description
Returns the maximum value of <expr>. The <expr> can be a numeric or date expression.
Example
SELECT MAX(sal) Maximum FROM accounts
Products
Recital, Recital Server