SQL MIN() and MAX()
Last updated
Was this helpful?
Last updated
Was this helpful?
The MIN() function returns the smallest value of the selected column.
The MAX() function returns the largest value of the selected column.
Below is a selection from the "Products" table in the Northwind sample database:
The following SQL statement finds the price of the cheapest product
Example