Difference between revisions of "SQL MIN()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Returns a minimum value in a SELECT statement | Returns a minimum value in a SELECT statement | ||
− | |||
==Syntax== | ==Syntax== | ||
MIN(<expr>) | MIN(<expr>) | ||
− | |||
==See Also== | ==See Also== | ||
[[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[COUNT()]], [[SQL MAX()|MAX()]], [[SQL SELECT|SELECT]], [[SUM()]] | [[SQL Aggregate Functions|AGGREGATES]], [[AVG()]], [[COUNT()]], [[SQL MAX()|MAX()]], [[SQL SELECT|SELECT]], [[SUM()]] | ||
− | |||
==Description== | ==Description== | ||
Returns the minimum value of <expr>. The <expr> can be a numeric or date expression. | Returns the minimum value of <expr>. The <expr> can be a numeric or date expression. | ||
− | |||
==Example== | ==Example== | ||
Line 20: | Line 16: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL|MIN()]] | [[Category:SQL|MIN()]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL Functions]] | [[Category:SQL Functions]] |
Revision as of 08:07, 7 December 2012
Contents
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