How can we use MySQL SUM() function with HAVING clause?-Mysql Tutorial-php.cn

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

WBOY

Release： 2023-09-23 09:17:06

forward

544 people have browsed it

我们如何将 MySQL SUM() 函数与 HAVING 子句一起使用？

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)

Copy after login

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)

Copy after login

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!