SQL MIN and MAX

SQL has many built-in functions to perform a calculation in SQL. In this tutorial, we will learn how to use MAX() and MIN() functions using SQL.

SQL MIN() and MAX() Functions

MIN() Function:

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

SELECT MIN(columnName)
FROM tableName
WHERE [CONDITION];

MAX() Function:

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

SELECT MAX(columnName)
FROM tableName
WHERE [CONDITION];

Example:

Let us consider this table "Employee" for records.

Table Name: Employee

Example of MIN() Function

Finding the lowest salary from the table "Employee", a query will be:

SELECT MIN(Salary) AS LowestSalary
FROM Employee;

Example of MAX() Function

Finding the highest salary from the table "Employee", a query will be:

SELECT MAX(Salary) AS HighestSalary
FROM Employee;