ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

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.

Usage 

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

Standards and compatibility 

• SQL/92    SQL/92 compatible.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

MIN function [Aggregate]

Example 

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

SELECT MAX( salary )
FROM employee