How to use the MAX function in MySQL

MySQL MAX function how to use, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this can learn, I hope you can gain something.

To understand the MAX function, consider an employee_tbl table with the following records-

mysql> SELECT * FROM employee_tbl;+------+------+------------+--------------------+| id | name | work_date | daily_typing_pages |+------+------+------------+--------------------+| 1 | John | 2007-01-24 | 250 || 2 | Ram | 2007-05-27 | 220 || 3 | Jack | 2007-05-06 | 170 || 3 | Jack | 2007-04-06 | 100 || 4 | Jill | 2007-04-06 | 220 || 5 | Zara | 2007-06-06 | 300 || 5 | Zara | 2007-02-06 | 350 |+------+------+------------+--------------------+7 rows in set (0.00 sec)

Now, assuming that you want to get the maximum value of daily_typing_pages based on the table above, you can simply do this with the following command:

mysql> SELECT MAX(daily_typing_pages) -> FROM employee_tbl;+-------------------------+| MAX(daily_typing_pages) |+-------------------------+| 350 |+-------------------------+1 row in set (0.00 sec)

You can use the GROUP BY clause to find all records with the largest value for each name, as follows-

mysql> SELECT id, name, MAX(daily_typing_pages) -> FROM employee_tbl GROUP BY name;+------+------+-------------------------+| id | name | MAX(daily_typing_pages) |+------+------+-------------------------+| 3 | Jack | 170 || 4 | Jill | 220 || 1 | John | 250 || 2 | Ram | 220 || 5 | Zara | 350 |+------+------+-------------------------+5 rows in set (0.00 sec)

You can also use the MIN function with the MAX function to find the minimum. Try the following example-

mysql> SELECT MIN(daily_typing_pages) least, MAX(daily_typing_pages) max -> FROM employee_tbl;+-------+------+| least | max |+-------+------+| 100 | 350 |+------+----+1 row in set (0.01 sec) Did it help you to read the above? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.