Applies the aggregate function to all values. ALL is the default.
Specifies that each unique value is considered. DISTINCT is not meaningful with MAX and is available for ISO compatibility only.
Is a constant, column name, or function, and any combination of arithmetic, bitwise, and string operators. MAX can be used with numeric, character, and datetime columns, but not with bit columns. Aggregate functions and subqueries are not permitted.