SQL MAX()

Purpose

Returns a maximum value in a SELECT statement

Syntax

MAX(<expr1> [, <expr2> [, ...]])

See Also

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

Description

Returns the maximum value of <expr1> or the list of expressions (list supported from v6.0).

The expressions can be of the following data types:

• Numeric
• Date
• Character (from v6.0)
• Currency (from v6.0)
• Datetime (from v6.0)

Example

open database southwind
select max(orderdate,requireddate,shippeddate) from orders
select max(companyname) from customers