MAX

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
X X X X

Selects the maximum value in each group of a column. Null values will be ignored. The format appears below:

MAX([DISTINCT]x)

where the parameter x is a column name.

Parent topic: Aggregate Functions