SQL MIN() Function
SQL MIN() function returns the smallest value from the selected column.
SELECT MIN(columnName) FROM TableName
To understand MIN() function we will take example from [SalesPerson] table of AdventureWorks2012 database. We are selecting all rows from SalesPerson table.
For demonstration we will find minimum of SalesYTD from SalesPerson table.
SELECT MIN(SalesYTD) AS SalesYTD FROM [Sales].[SalesPerson]
You can refer the output and compare from SalesYTD column in SalesPerson table as it is the minimum value from that column.
Similarly, we will take one more example from Bonus column as follows.
SELECT MIN(Bonus) AS MINBonus FROM [Sales].[SalesPerson]
– Min() function ignores null values.
– For character columns, Min() function finds the lowest value from collating order i.e. from alphabets A-Z, it will return ‘A’ as minimum value.
Reference: Manzoor Siddiqui [www.SQLServerLog.com]