MySQL provides inbuilt functions to find the minimum and maximum values.
SQL provides 5 aggregate functions. They are:
In this session of the online MySQL course, we'll look at finding the minimum and maximum values in a column.
select MIN(salary) from employee_data; +-------------+ | MIN(salary) | +-------------+ | 70000 | +-------------+ 1 row in set (0.00 sec)
select MAX(salary) from employee_data; +-------------+ | MAX(salary) | +-------------+ | 200000 | +-------------+ 1 row in set (0.00 sec)
Page contents: Online mysql course - finding the minimum and maximum values - mysql min and max functions
Comments, questions, feedback... whatever!