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.