Determine the price of the least expensive product in the “Products” table.
| SELECT Min(Price) AS SmallestPrice FROM Products; |
The Min() function returns the smallest value in a set of values.
Note: See also the Max() function.
| Min(expression) |
|
Parameter |
Description |
|
expression |
Required: A numeric value, which may be a field or a formula. |
|
WORKS IN |
From Access 2000 |