The SQL MAX function returns the largest 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 maximum age in the employees table.
Syntax
SELECT MAX(column_name)
FROM Table |
Example
SELECT MAX(age) as [Max Age]
FROM employees
|
Results
The SQL MAX function is used to find the largest 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
