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