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.

The aggregate functions can be used in conjunction with the WHERE clause to gain further insights from our data. One of these is the MIN() function. In SQL, the MIN() function is used to compute the smallest or minimum value of numeric values in a column.

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.