MySQL Function Reference

MAX

Returns the maximum value from a set of values.

MySQL 8.1

MAX(expr)

expr

An expression to find the maximum value for

Examples

MySQL 8.1

SELECT MAX(unit_price)
FROM Payments;