Determine the price of the highest-priced item in the “Products” table.
| SELECT Max(Price) AS LargestPrice FROM Products; |
The Max() function retrieves the highest value from a set of values.
Note: Refer to the Min() function for finding the minimum value.
| Max(expression) |
|
Parameter |
Description |
|
expression |
Required: A numeric value, which can be either a field or a formula. |
|
WORKS IN |
From Access 2000 |