SQL MIN()

From Recital Documentation Wiki
Revision as of 16:19, 28 October 2009 by Helengeorge (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;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer