The SQL MIN function returns the smallest value of the selected column.
Employees Table
| employeeID | employeeName | age |
|---|
| 1000 | John Smith | 40 |
| 1001 | Fred White | 27 |
| 1002 | Jane Scott | 53 |
| 1003 | Samuel Williams | 31 |
In this example, we want to find the minimum age in the employees table.
Syntax
SELECT MIN(column_name)
FROM Table |
Example
SELECT MIN(age) as [Min Age]
FROM employees
|
Results
The SQL MIN function is used to find the smallest value in a given column.
Did you find the page informational and useful? Share it using one of your favorite social sites.
Recommended Books & Training Resources
