SQL MIN() Function

SQL MIN() Syntax

The below syntax is used to select specific column from the specific table.

SELECT MIN(column_name1) FROM table_name;

Sample Database Table - Employee

SQL MIN() Example

The following SQL SELECT statement find the lowest or minimum value of "Salary" column from the "Employee" table:

SELECT 
MIN(Salary) As 'Minimum Salary' 
FROM Employee;

The result of above query is:

SQL MIN() Example - Using Group By Clause

The following SQL SELECT statement find the lowest or minimum salary in all "Dept" column from the "Employee" table:

SELECT 
Dept, MIN(Salary) As 'Minimum Salary' 
FROM Employee 
GROUP BY Dept;

The result of above query is: