In MySQL, MIN() function is used to return the smallest value of the specified column in a table.

MIN() Syntax

SELECT MIN(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

MIN() Example

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

SELECT MIN(salary) AS highest_salary FROM employee;

Hope this will help you :)