SQL MIN() function

May 16, 2021 SQL

1. SQL MIN() Function

2. Demonstrate the database

3. SQL MIN() instance

4. Chapter test

SQL MIN() Function

MIN() function

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

SQL MIN() syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

Demonstrate the database

In this tutorial, we'll use the famous Northwind sample database.

Here's the data from the Products table:

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
1	Chais	1	1	10 boxes x 20 bags	18
2	Chang	1	1	24 - 12 oz bottles	19
3	Aniseed Syrup	1	2	12 - 550 ml bottles	10
4	Chef Anton's Cajun Seasoning	2	2	48 - 6 oz jars	22
5	Chef Anton's Gumbo Mix	2	2	36 boxes	21.35

SQL MIN() instance

The following SQL statement looks for the price of the cheapest product:

SELECT MIN(Price) AS SmallestPrice
FROM Products;

Chapter test

Now, take a look at how well you know the SQL MIN() function with the following topics!

SQL MIN() functions: In this section of the quiz, you will practice using sql MIN() functions to complete selecting the appropriate statements from the specified table and filtering by criteria.

Click here to test

Note: The above tests are paid and premium VIP is free of charge