Revision as of 13:19, 19 March 2009

MIN()

Class

SQL Applications

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 Database Server, Recital Mirage Server, Recital Terminal Developer