SQL MIN()

From Lianjapedia
Revision as of 08:07, 7 December 2012 by Helen.george (Talk | contribs)

Jump to: navigation, search

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