MySQL Max Function

MySQL Max() function fetches the max value in a set of values in a table column.

Syntax:

MAX(exp)

Example:

Let us use the 'emp' table and fetch the max valued office code.

select max(officeCode) from emp

So this is how we can use the max function in MySQL effectively.