MAX

An aggregate function that returns the highest value in a group, for example MAX(length). It ignores NULLs.

sql
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.

Appears in

No references yet.