使用SUM()的MYSQL选择查询 [英] MYSQL Select Query with SUM()
本文介绍了使用SUM()的MYSQL选择查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有下表:
| campaign_id | source_id | clicked | viewed |
----------------------------------------------
| abc | xxx | 0 | 0 |
| abc | xxx | 1 | 0 |
| abc | xxx | 1 | 1 |
| abc | yyy | 0 | 0 |
| abc | yyy | 1 | 0 |
| abc | yyy | 1 | 1 |
| abc | yyy | 0 | 0 |
我需要以下输出:
xxx > Total: 3 // Clicked: 2 // Viewed 1
yyy > Total: 4 // Clicked: 2 // Viewed 1
我知道我必须在查询中使用某种SUM(),但我不知道如何在source_id中的多个唯一值之间进行区分(例如foreach,idk).
I know that I have to use some sort of SUM() in my query, but I don't know how to differ between those multiple unique values in the source_id (something like foreach, idk).
如何仅通过一个查询就可以显示所有唯一source_ids的统计信息?
How can I get such an output which shows stats from all unique source_ids by using only one query?
推荐答案
尝试一下:
SELECT source_id, (SUM(clicked)+SUM(viewed)) AS Total
FROM your_table
GROUP BY source_id
这篇关于使用SUM()的MYSQL选择查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文