select sum(case when dh%4=1 then sl else 0 end) as sl1,
sum(case when dh%4=2 then sl else 0 end) as sl2,
sum(case when dh%4=3 then sl else 0 end) as sl3,
sum(case when dh%4=0 then sl else 0 end) as sl4
from yourtable
group by (dh-1)/4
sum(case when dh%4=2 then sl else 0 end) as sl2,
sum(case when dh%4=3 then sl else 0 end) as sl3,
sum(case when dh%4=0 then sl else 0 end) as sl4
from yourtable
group by (dh-1)/4
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货