Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Aggregate Functions > MAX

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
Previous Topic Next topic Print topic