笔记：Oracle的列行转换：

突然用到先记一点在这，有时间再来整理；

---------------------------------行列转换------------------------------------
create table SQL_food(
       name varchar(20),
       type varchar(20),
       value number
)

insert into SQL_food values('lee','Breakfast',10);
insert into SQL_food values('Lee','Lunch',20);
insert into SQL_food values('LEE','Supper',30);

select * from SQL_food;

select lower(name),type,value from SQL_food

delete SQL_food;

select name,Breakfast,Lunch,Supper
       from SQL_food
       PIVOT(value for type in('Breakfast' as Breakfast,'Lunch' as Lunch,'Supper' as Supper));
       
select name,
       max(decode(s.type,'Breakfast',s.value)) as "Breakfast",
       max(decode(s.type,'Lunch',s.value)) as "Lunch",
       max(decode(s.type,'Supper',s.value)) as "Supper"
       from (select lower(name) name,type,value from SQL_food) s
       group by name;


select Rq,
       count(decode(ShengFu,'胜',1)) as 胜,
       count(decode(ShengFu,'负',1)) as 负 
       from 表四
       group by Rq