Returns the maximum value in the expression. Ignores all NULL values.
MAX ( [ DISTINCT ] expression )
An expression that is a numeric, date/time, or literal.
DISTINCT Specifies that each unique value is considered. DISTINCT is not meaningful with MAX.
Returns a value same as expression.
This example finds the highest (maximum) price in the
SELECT MIN(price) FROM pricing;