MAX
An aggregate function that returns the highest value in a group, for example MAX(length). It ignores NULLs.
SELECT MAX(length) FROM film;
When to use
Not asked directly in the past papers; it is one of the five aggregates (COUNT, SUM, AVG, MIN, MAX) and, like MIN, is allowed in HAVING but not in WHERE (PP 01 Q4.3).
See Read 01.