How can we use MySQL SUM() function with HAVING clause?

By using the MySQL SUM() function with the HAVING clause, it filters the results based on specific criteria given after the HAVING clause. To understand the above concept, consider an "employee_tbl" table which has 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, the following query will use HAVING clause and SUM() function to get the total number of daily_typing_pages over 250.

mysql> Select Name, SUM(daily_typing_pages) From employee_tbl GROUP BY NAME HAVING SUM(daily_typing_pages) > 250;
+------+-------------------------+
| name | SUM(daily_typing_pages) |
+------+-------------------------+
| Jack |          270            |
| Zara |          650            |
+------+-------------------------+
2 rows in set (0.17 sec)

The above is the detailed content of How can we use MySQL SUM() function with HAVING clause?. For more information, please follow other related articles on the PHP Chinese website!