Skip to main content

SQL Min() Function

Body

The MIN function is use to return the smallest value of the selected column. MIN can be use only in numeric column.

As with other function, you can also give an Alias to the MIN function.

SQL MIN() Syntax

SELECT Min(column_name) FROM Table

Consider the following table for this exercise

Users

Firstname Lastname Salary DeptID
John Smith 1000 1
Mathew Simon 3000 1
Bill Steve 2200 1
Amanda Rogers 1800 2
Steve Hills 2800 2
Steve jobs 2400 2
bill cosby 700 3

Example # 1

SELECT Min(Salary) AS MinimumSalary FROM Users

Result of the Query

MinimumSalary
700

The query Returns the smallest salary from the dataset.

Add new comment