select 卡号,sum(case when 说明 = '消费' then 1 else 0 end) as 消费次数,
sum(case when 说明 = '充值' then 1 else 0 end) as 充值次数,
sum(case when 说明 = '消费' then 金额 else 0 end) as 消费金额,
sum(case when 说明 = '充值' then 金额 else 0 end) as 充值金额
from 表
group by 卡号
sum(case when 说明 = '充值' then 1 else 0 end) as 充值次数,
sum(case when 说明 = '消费' then 金额 else 0 end) as 消费金额,
sum(case when 说明 = '充值' then 金额 else 0 end) as 充值金额
from 表
group by 卡号
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货