select itemcode 名称,to_char(trunc(cdate,'mm'),'yyyy.mm') 年月,
sum(decode(to_char(cdate,'dd'),'01',data) 1日,
sum(decode(to_char(cdate,'dd'),'02',data) 2日,
sum(decode(to_char(cdate,'dd'),'03',data) 3日,
...
sum(decode(to_char(cdate,'dd'),'31',data) 31日
from t1
group by itemcode,trunc(cdate,'mm')
order by itemcode,trunc(cdate,'mm');
sum(decode(to_char(cdate,'dd'),'01',data) 1日,
sum(decode(to_char(cdate,'dd'),'02',data) 2日,
sum(decode(to_char(cdate,'dd'),'03',data) 3日,
...
sum(decode(to_char(cdate,'dd'),'31',data) 31日
from t1
group by itemcode,trunc(cdate,'mm')
order by itemcode,trunc(cdate,'mm');
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货