MySQL MIN() and MAX() Functions

MySQL MIN() and MAX() Functions

 

The MIN() function returns the smallest value of the selected column and the MAX() function returns the largest value of the selected column.

MIN() Syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

MAX() Syntax

SELECT MAX(column_name)
FROM table_name
WHERE condition;