Difference between revisions of "SQL MIN()"

From Lianjapedia
Jump to: navigation, search
 
m (1 revision: SQL)
(No difference)

Revision as of 04:17, 25 October 2011

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