mysql合并搜索结果并比较

Question

比如
+-----+---------+
| id | count |
+-----+---------+
| 1 | 4 |
| 2 | 5 |
| 3 | 1 |
| 4 | 2 |
| 4 | 3 |
| 2 | 1 |
| 3 | 6 |
| 1 | 4 |
+-----+---------+
我想相同id的结果合并（count相加）并且筛选出相加后count大于7的结果要怎么写

Answer 1

就按照你的例子简单写一个

 SELECT id, SUM(count) FROM TAB GROUP BY id HAVING   SUM(count) >7