MIN

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

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

MIN([DISTINCT]x)

where the parameter x is a column name.

Note:

The DISTINCT keyword is ignored in the MAX and MIN functions.

Parent topic: Aggregate Functions