MIN returns the minimum or lowest value from a set of values.
This function ignores NULL values.
This example returns the minimum, or lowest, product price.
SELECT MIN(UnitPrice) AS 'Min'
FROM Product
| Min |
|---|
| 2.50 |
Syntax of the MIN function.
MIN(value)
value -- a value, column, or subquery.
| ORDER |
|---|
| Id |
| OrderDate |
| OrderNumber |
| CustomerId |
| TotalAmount |
SELECT MONTH(OrderDate) AS Month
MIN(TotalAmount) AS 'Total Sales'
FROM [Order]
WHERE YEAR(OrderDate) = 2013
GROUP BY MONTH(OrderDate)
| Month | Min Order Amount |
|---|---|
| 1 | 49.80 |
| 2 | 174.90 |
| 3 | 147.00 |
| 4 | 136.80 |
| 5 | 110.00 |
 |
|
| PRODUCT |
|---|
| Id |
| ProductName |
| SupplierId |
| UnitPrice |
| Package |
| IsDiscontinued |
| SUPPLIER |
|---|
| Id |
| CompanyName |
| ContactName |
| City |
| Country |
| Phone |
| Fax |
SELECT S.CompanyName,
MIN(UnitPrice) AS 'Lowest Price'
FROM Product P
JOIN Supplier S ON S.Id = P.SupplierId
GROUP BY S.CompanyName
| CompanyName | Lowest Price |
|---|---|
| Aux joyeux ecclésiastiques | 18.00 |
| Bigfoot Breweries | 14.00 |
| Cooperativa de Quesos 'Las Cabras' | 21.00 |
| Escargots Nouveaux | 13.25 |
| Exotic Liquids | 10.00 |
|
|
