MAX function [Aggregate]

Function

Returns the maximum expression value found in each group of rows.

Syntax

MAX ( expression
| DISTINCT column-name )

Parameters

expression The expression for which the maximum value is to be calculated. This is commonly a column name.

DISTINCT column-name Returns the same as MAX ( expression ), and is included for completeness.

Example

The following statement returns the value 138948.000, representing the maximum salary in the employee table:

SELECT MAX ( salary )
FROM employee

Usage

Rows where expression is NULL are ignored. Returns NULL for a group containing no rows.

Standards and compatibility

SQL92 SQL92 compatible.

Sybase Compatible with Adaptive Server Enterprise.

See also

“MIN function [Aggregate]”

Chapter 4, “Using OLAP” in the Sybase IQ Performance and Tuning Guide