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;