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