MIN function in SQL Server

The article will explore and show you how to use the MIN function in SQL Server to find the smallest value in a set.

Describe

The MIN function in SQL Server is an aggregate function that returns the smallest value in a group.

Syntax

To use the MIN function in SQL Server, we use the following syntax:

 SELECT MIN(cot) 
 FROM bang 
 [WHERE dieukien]; 

Parameters :

1. cot: column or calculated value, the expression you want to find the smallest value
2. state: the table used to retrieve the record. Must have at least 1 table in the FROM clause.
3. dieukien: optional. Conditions that the record must meet to be selected.

Note :

1. The MIN function can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

For example

Take a look and explore some examples of MIN functions in SQL Server.

Suppose, we have the following data table:

MIN function in SQL Server Picture 1

Example 1: Find the minimum number of posts in the table

 SELECT MIN(Sobai) 
 FROM Quantrimang 
 WHERE Sobai > 120; 
 
 Result: 122 

In this example we have the minimum number of articles in a column in the Quantrimang table, which must be greater than 120.

Example 2: Use GROUP BY

The following example finds the smallest value of all records related to a large section, you will do the following:

 SELECT Chuyenmuclon, MIN(Sobai) AS 'So bai it nhat' 
 FROM Quantrimang 
 GROUP BY Chuyenmuclon; 
 
 Result: 
 Chuyenmuclon So bai it nhat 
 Laptrinh 101 
 Mang xa hoi 152 
 Trinh duyet web 94 

Previous post: MAX function in SQL Server

Next: RAND function in SQL Server