SQL MAX()

MAX()

Class

SQL Applications

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