The MAX function

The MAX() function returns the largest value of the selected column.

The syntax for the max function in [[The SELECT statement]] is:

SELECT MAX(column_name)
FROM table_name
WHERE condition;