Javatpoint Logo
Javatpoint Logo


The MAX is an aggregate function in Structured Query Language that returns the largest value from the multiple values of the column in the table.

Syntax of SQL Max() Function

We can also use the WHERE condition for selecting the maximum value from the specific records.

Two Examples of SQL Max Function

In this article, you will learn how to use the MAX function in SQL by the following two examples.

Example 1: This example describes how to use the MAX function in SQL.

Let's create a simple table on which the MAX function is to be run.

The following CREATE TABLE statement creates the Cars_Details table with five fields:

The following INSERT query inserts the records of cars into the Cars_Details table:

The following SELECT query shows the data of the Cars_Details table:

Car_Number Car_Name Car_Amount Car_Price
2578 Creta 3 900000
9258 Audi 2 1100000
8233 Venue 6 900000
8990 Nexon 7 700000
9578 Mercedes 6 8000000
1258 Thar 2 1500000
2564 Jaguar 4 6000000
2155 Scorpio 8 1800000

The following query shows the largest Car_Number from the above Car_Details table:



Example 2: This example describes how to use the MAX function with the WHERE clause in the SELECT statement:

The following query creates the College_Student_Details table using the CREATE TABLE statement:

The following SQL queries insert the record of students into the above table using INSERT INTO statement:

Let's see the record of the above table using the following SELECT statement:

Student_ID Student_Name Student_Course Student_Age Student_Marks
101 Anuj 20 88
102 Raman MCA 24 98
104 Shyam BBA 19 92
107 Vikash 20 78
111 Monu MBA 21 65
114 Jones 18 93
121 Parul BCA 20 97
123 Divya 21 89
128 Hemant MBA 23 90
130 Nidhi BBA 20 88
132 Priya MBA 22 99
138 Mohit MCA 21 92

The following MAX query displays the highest marks under 80 from the above Student_Details table:



MAX Function with SQL GROUP BY clause

The MAX Function with GROUP BY clause shows the highest value in each group from the table.

The syntax to use Group BY Clause with MAX Function is given below:

Example of MAX Function with GROUP BY Clause

Let's take the above College_Student_Details table to understand the concept of MAX function With GROUP BY Clause.

The following query shows the highest marks of student in each course from the above College_Student_Details table:


Student_Course AVG (Student_Marks) 93
MCA 98
BBA 92
MBA 99
BCA 97


Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA