MAX Function in SQL Server: What You Need to Know

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

Describe

The MAX function in SQL Server is an aggregate function that returns the maximum value in a group.

Syntax

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

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

Parameters :

1. cot: column or calculated value, expression you want to find the largest 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. MAX 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 instance,

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

Suppose, we have the following data table:

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

 SELECT MAX(Sobai) 
 FROM Quantrimang 
 WHERE Sobai < 100; 
 
 Result: 122 

In this example we have the highest number of articles in a column in the Quantrimang table, where the number of posts is less than 100.

Example 2: Use GROUP BY

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

 SELECT Chuyenmuclon, MAX(Sobai) AS 'So bai nhieu nhat' 
 FROM Quantrimang 
 GROUP BY Chuyenmuclon; 
 
 Result: 
 Chuyenmuclon So bai nhieu nhat 
 Laptrinh 122 
 Mang xa hoi 165 
 Trinh duyet web 94 

Next lesson: MIN function in SQL Server