Retrieve the price of the lowest-priced product from the “Products” table.
| SELECT MIN(Price) AS SmallestPrice FROM Products; |
The MIN() function retrieves the lowest value within a set of values.
Note: Also refer to the MAX() function for finding the maximum value.
| MIN(expression) |
|
Parameter |
Description |
|
expression |
Mandatory: A numerical value, which can be either a field or a formula. |
| Works in: | From MySQL 4.0 |