SQL MAX()

From Recital Documentation Wiki
Revision as of 17:16, 22 December 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Returns a maximum value in a SELECT statement


Syntax

MAX(<expr>)


See Also

AGGREGATES, AVG(), COUNT(), MIN(), SELECT, SUM()


Description Returns the maximum value of <expr>. The <expr> can be a numeric or date expression.


Example

SELECT MAX(sal) Maximum FROM accounts


Products

Recital, Recital Server