MySQL provides inbuilt functions to find the minimum and maximum values.
SQL provides 5 aggregate functions. They are:
1). MIN(): Minimum value
2). MAX(): Maximum value
3). SUM(): The sum of values
4). AVG(): The average values
5). 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.
Minimum value
select MIN(salary) from employee_data;
+-------------+
| MIN(salary) |
+-------------+
| 70000 |
+-------------+
1 row in set (0.00 sec)
Maximum value
select MAX(salary) from employee_data;
+-------------+
| MAX(salary) |
+-------------+
| 200000 |
+-------------+
1 row in set (0.00 sec)
- List the minimum perks package.
- List the maximum salary given to a "Programmer".
- Display the age of the oldest "Marketing Executive".
- (Tricky!) Find the first and last names of the oldest employee.