In MySQL, the MAX() function used to return the largest value of the specified column in a table.

MAX() Syntax

SELECT MAX(column_name) FROM table_name;

We have a table "employee" as below:

    employee
    id  first_name            last_name       salary
    .......................................................
    1   John                     Simp         10000
    2   Chris                    Hely         25000
    3   Joy                      Roy          20000
    4   Jenny                    Mill         35000

MAX() Example

The below query gives the largest value of the "salary" column from the "employee" table:

SELECT MAX(salary) AS highest_salary FROM employee; 

Hope this will help you :)