# MIN Function in SQL

The MIN is an aggregate function in SQL which returns the minimum or smallest value from the specified column of the table.

### Syntax of MIN Function

In the Structured Query Language, we use the MIN function with the columns of the table as shown in the following block:

### Example of MIN function

Here, we will create the new table through which we will perform the MIN function with the columns of the table:

The following shows the syntax to create the new table in SQL:

The following CREATE statement creates the Product_Details table for storing the price and quantity of products:

The following multiple INSERT queries insert the records of products with their selling and purchasing price into the Product_Details table:

The following SELECT statement displays the inserted records of the above Product_Details table:

Product_ID Product_Name Product_Quantity Purchasing_Price Selling_Price Release_Date Category Product_Rating
104 P1 10.250 945 NULL 2022-04-30 Cloths NULL
202 P4 15.500 45 75 2022-01-28 Electrical 5
103 P2 18.250 25 NULL 2022-02-18 Toys 4
111 P7 25.250 5 15 2021-12-25 Cloths 9
210 P6 15.500 50 70 2021-10-15 Electrical NULL
212 P8 19.750 110 250 2022-01-28 Cloths 4
112 P10 10.250 550 835 2022-04-11 Toys NULL

Query 1: The following SELECT query uses the MIN function with the Product_Quantity column of the above Product_Details table:

This query shows the smallest value of product quantity column.

Output:

Minimum_in_productquantity
10.250

Query 2: The following SELECT query uses the MIN function with the Selling_Price column of the above Product_Details table:

This query returns the minimum value of selling price products.

Output:

Minimum_in_sellingpriceproducts
15

Query 3: The following SELECT query uses the MIN function with the Product_Rating column of the above Product_Details table:

This query returns the smallest values of Product_rating columns.

Output:

Minimum_in_productrating
4

Query 4: The following SELECT query uses the MIN function with the addition of two columns of the above Product_Details table:

This query returns the smallest values from the addition of purchasing and selling price.

Output:

20

## MIN Function with WHERE clause

We can also use the WHERE clause with the MIN function which returns the smallest value from the filtere rows.

The syntax for using the MIN function with the WHERE clause is as follows:

Query 1: The following SELECT query uses the MIN function with WHERE clause in the above Product_Details table:

This query returns the smallest quantity from those products whose product id is greater than 200.

Output:

Minimum_in_product>200
15.500

Query 2: The following SELECT query uses the MIN function with WHERE clause in the above Product_Details table:

This query returns the smallest purchasing price from those products which are release on 2022-01-28.

Output:

15.500

## MIN Function with GROUP BY clause

We can also use the GROUP BY clause with the MIN function which returns the minimum value from the same group.

The syntax for using the MIN function with the GROUP BY clause is as follows:

Query 1: The following SELECT query uses the MIN function with the GROUP BY clause in the above Product_Details table:

This query returns the minimum value of each specified group.

Output:

Category Minimum_in_samegroup
Cloths 10.250
Toys 10.250
Electrical 15.500