MySQLMIN() Function
Example
Find the price of the cheapest product in the "Products" table:
SELECT MIN(Price) AS SmallestPrice FROM Products;
Try it Yourself »Definition and Usage
The MIN() function returns the minimum value in a set of values.
Note: See also theMAX() function.
Syntax
MIN(expression)
Parameter Values
| Parameter | Description |
|---|---|
| expression | Required. A numeric value (can be a field or a formula) |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
