MAX

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.