Max

Description

Computes the maximum value of an aggregation of values. The value is returned with the same data type as the column data type.

Syntax

Max ( n )

Arguments

n is a numeric expression.

Remarks

Max is an aggregation function which can only be used in an aggregating Select statement. Null values are ignored. If there are only null values supplied in the aggregation, then a null value is returned.