id level count
1 1 15
1 2 18
1 6 33SELECT ID,SUM(DECODE(LEVEL,1,COUNT,0)) C1,SUM(DECODE(LEVEL,2,COUNT,0)) C2,SUM(DECODE(LEVEL,3,COUNT,0)) C3,SUM(DECODE(LEVEL,4,COUNT,0)) C4,SUM(DECODE(LEVEL,5,COUNT,0)) C5,SUM(DECODE(LEVEL,6,COUNT,0)) C6
GROUP BY ID;
1 1 15
1 2 18
1 6 33SELECT ID,SUM(DECODE(LEVEL,1,COUNT,0)) C1,SUM(DECODE(LEVEL,2,COUNT,0)) C2,SUM(DECODE(LEVEL,3,COUNT,0)) C3,SUM(DECODE(LEVEL,4,COUNT,0)) C4,SUM(DECODE(LEVEL,5,COUNT,0)) C5,SUM(DECODE(LEVEL,6,COUNT,0)) C6
GROUP BY ID;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货