Difference between revisions of "SQL MAX()"

Revision as of 04:17, 25 October 2011

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