下表跟踪每个广告系列的点击次数和浏览次数:
record_id advert_id type
-----------------------------------
1 100 click
2 102 click
3 100 view
4 100 view
5 102 view
6 100 view
7 101 view
8 101 click
是否可以通过单个查询聚合点击次数和浏览次数,即,使其看起来像这样:
advert_id clicks views
-------------------------------
100 1 3
101 1 1
102 1 1
通过...分组advert_id
并使用条件聚合
select advert_id,
sum(type = 'click') as clicks,
sum(type = 'view') as views
from your_table
group by advert_id
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)