Mastering the MAX() Aggregate Function in SQL: A Complete Guide

The MIN() function returns the smallest value of the selected column.

The MAX() function returns the largest value of the selected column.

Syntax:

<span class="pln">
SELECT MAX</span><span class="pun">(</span><span class="pln">column_name</span><span class="pun">)</span><span class="pln">
FROM table_name
WHERE condition</span><span class="pun">;</span><span class="pln">
</span>

We will apply MAX function in this blow table:

We will find the maximum Salary

Example: MAX

Code:

<span class="pln">
SELECT MAX</span><span class="pun">(</span><span class="typ">EmpSalary</span><span class="pun">)</span><span class="pln"> AS </span><span class="typ">MaxSalary</span><span class="pln"> FROM </span><span class="typ">EmployeeDetails</span><span class="pln"> 
</span>

Output:

The above code will produce the following result-

<span class="pln">
</span><span class="typ">MaxSalary</span><span class="pln">
</span><span class="lit">33000</span><span class="pln">
</span>

Code: Code For table creation and Data Insertion

<span class="pln">
USE </span><span class="typ">SQLExamples</span><span class="pln">

DROP TABLE </span><span class="typ">EmployeeDetails</span><span class="pln">

CREATE TABLE </span><span class="typ">EmployeeDetails</span><span class="pun">(</span><span class="pln">
</span><span class="typ">EmpId</span><span class="pln"> </span><span class="kwd">int</span><span class="pun">,</span><span class="pln">
</span><span class="typ">EmpName</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">30</span><span class="pun">),</span><span class="pln">
</span><span class="typ">EmpAddress</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln">
</span><span class="typ">EmpSalary</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">10</span><span class="pun">),</span><span class="pln">
</span><span class="typ">EmpDept</span><span class="pln"> VARCHAR</span><span class="pun">(</span><span class="lit">10</span><span class="pun">)</span><span class="pln">
</span><span class="pun">)</span><span class="pln">

INSERT INTO </span><span class="typ">EmployeeDetails</span><span class="pln"> VALUES
</span><span class="pun">(</span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Rambo'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Kolkata'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'30000'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'ADMIN'</span><span class="pun">),</span><span class="pln">
</span><span class="pun">(</span><span class="lit">2</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Inza'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Bihar'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'31000'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'SALES'</span><span class="pun">),</span><span class="pln">
</span><span class="pun">(</span><span class="lit">3</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Samser'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Kolkata'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'32000'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'IT'</span><span class="pun">),</span><span class="pln">
</span><span class="pun">(</span><span class="lit">4</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Kamran'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Hydrabad'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'33000'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'ITIS'</span><span class="pun">),</span><span class="pln">
</span><span class="pun">(</span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Azam'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'Kolkata'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'33000'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'ITIS'</span><span class="pun">)</span><span class="pln">

SELECT </span><span class="pun">*</span><span class="pln"> FROM </span><span class="typ">EmployeeDetails</span><span class="pln">
</span>