SQL MAX() Function

The SQL MAX() is a function, and return the largest or highest value of a numeric table column from query result.

The SQL MAX() function is supports only numeric column.

It can be used in SQL SELECT statement as well in SQL WHERE clause.

You can also search these topics using sql where max date, select max id from table, sql max of two values, sql server select max, get max value in sql, sql select max value, select max value from table.

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

ID	EmpName	Designation	Dept	JoinYear	Salary
1	Vidyavathi	Database Designer	MySQL	2014	15440
2	Harish Karthik	Employee	HTML	2015	17540
3	Hari Krishnan	Manager	Oracle	2015	17330.2
4	Sakunthala	Web Mining	Java	2012	5990.3
5	Hanumanthan	Project Lead	Java	2012	8510.9
6	Keshavan	Mobile Database	HTML	2015	16910.2

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:

Maximum Salary
17540

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:

Dept	Maximum Salary
HTML	17540
Java	8510.9
MySQL	15440
Oracle	17330.2

You can also search these topics using sql get maximum value, max keyword in sql, sql query max value, aggregate functions in sql, sql aggregate functions examples.