队列置换oracle

行列置换oracle

?

?create table sale_list(month varchar(6),sell number(11,2));insert into sale_list values('201101',1000);insert into sale_list values('201102',2000);insert into sale_list values('201103',3000);insert into sale_list values('201104',4000);insert into sale_list values('201105',5000);insert into sale_list values('201106',6000); commit;

?

　

?

DECODE(value, if1, then1, if2,then2, if3,then3, . . . else )

????? select

???? 　substrb(month,1,4),

???? 　sum(decode(substrb(month,5,2),'01',sell,0)) "1",　　　　sum(decode(substrb(month,5,2),'02',sell,0)) "2",　　　　sum(decode(substrb(month,5,2),'03',sell,0)) "3",　　　　sum(decode(substrb(month,5,2),'04',sell,0)) "4",　　　　sum(decode(substrb(month,5,2),'05',sell,0)) "5",　　　　sum(decode(substrb(month,5,2),'06',sell,0)) "6"　　　　from sale_list

　　　　group by substrb(month,1,4);

查看更多 下一篇