Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We find the minimum value in a column in a dataset, with the MIN Function and we find the maximum value in a column in a dataset, with the with the MAX Function.
Let’s make examples for a better understanding of MIN and MAX Functions.
Example:
First, we create a table with the help of the following script and add a few records into this table.
1 2 3 4 5 6 | CREATE TABLE [dbo].[MyTable] ([ID] INT IDENTITY, [Name] VARCHAR(20), [Age] INT) INSERT [dbo].[MyTable] VALUES ('Hakan GURBASLAR',36),('Nurullah CAKIR',34),('Faruk ERDEM',27) |
MIN Function Usage:
We find the minimum age value in the table with the following script.
1 | SELECT MIN(Age) From [dbo].[MyTable] |
MAX Function Usage:
We find the maximum age value in the table with the following script.
1 | SELECT MAX(Age) From [dbo].[MyTable] |
We usually use the MIN and MAX functions with GROUP BY Clause. You can find detailed information in the following article.
“Group By Clause, SUM, MAX, MIN, AVG, COUNT and COUNT_BIG Functions in SQL Server”
