select b,count(col1) c1,count(col2) c2,count(col3) c3
from (
select b,decode(mod(rownum/3),1,c,0) col1,decode(mod(rownum/3),2,c,0) col2,
decode(mod(rownum/3),0,c,0) col3 from(select * from tbname order by b)
) group by b;
from (
select b,decode(mod(rownum/3),1,c,0) col1,decode(mod(rownum/3),2,c,0) col2,
decode(mod(rownum/3),0,c,0) col3 from(select * from tbname order by b)
) group by b;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货