cot: column or calculated value, the expression you want to find the smallest value
state: the table used to retrieve the record. Must have at least 1 table in the FROM clause.
dieukien: optional. Conditions that the record must meet to be selected.
Note :
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:
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
the article will give you detailed instructions on how to use the sql server round () function with the syntax and specific examples to make it easier to visualize and capture the function better.
the datename function in sql server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... the return value is a string type (ascii)
this article will show you in detail how to use sql server's datetime datediff () function with syntax and specific examples to make it easier to visualize and capture functions.