select
a.year,
a.id,
sum(decode(a.type,1,a.money,0)) money1,
sum(decode(a.type,2,a.money,0)) money2,
sum(decode(a.type,3,a.money,0)) money3,
sum(decode(a.type,4,a.money,0)) money4
from
tableA a
group by
a.year,
a.id
a.year,
a.id,
sum(decode(a.type,1,a.money,0)) money1,
sum(decode(a.type,2,a.money,0)) money2,
sum(decode(a.type,3,a.money,0)) money3,
sum(decode(a.type,4,a.money,0)) money4
from
tableA a
group by
a.year,
a.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货