SQL MAX() Function

SQL MAX() Syntax

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

SELECT MAX(column_name1) FROM table_name;

Sample Database Table - Employee

SQL MAX() Example

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

SELECT 
MAX(Salary) As 'Maximum Salary' 
FROM Employee;

The result of above query is:

SQL MAX() Example - Using Group By Clause

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

SELECT 
Dept, MAX(Salary) As 'Maximum Salary' 
FROM Employee 
GROUP BY Dept;

The result of above query is: