The MIN()
function returns the smallest value of the selected column.
The MAX()
function returns the largest value of the selected column.
MIN() Syntax
SELECT MIN(column_name)
FROM table_name
WHERE condition;
FROM table_name
WHERE condition;
MAX() Syntax
SELECT MAX(column_name)
FROM table_name
WHERE condition;
FROM table_name
WHERE condition;
Practice Excercise Practice now