队列置换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);