Online MySQL course – Finding the minimum and maximum values

MySQL provides inbuilt functions to find the minimum and maximum values.

SQL provides 5 aggregate functions. They are:

• MIN(): Minimum value
• MAX(): Maximum value
• SUM(): The sum of values
• AVG(): The average values
• COUNT(): Counts the number of entries

In this session of the online MySQL course, we’ll look at finding the minimum and maximum values in a column.

MySQL MIN() – Minimum value

select MIN(salary) from employee_data;

+-------------+
| MIN(salary) |
+-------------+
|       70000 |
+-------------+
1 row in set (0.00 sec)

MySQL MAX() – Maximum value

select MAX(salary) from employee_data;

+-------------+
| MAX(salary) |
+-------------+
|      200000 |
+-------------+
1 row in set (0.00 sec)