pivot 与 unpivot 函数是SQL05新提供的2个函数 灰常灰常的实用
------------------------------------------------------------------------------
pivot函数:
create table test(id int,name varchar(20),quarter int,profile
int)
insert into test values(1,'a',1,1000)
insert into test values(1,'a',2,2000)
insert into test values(1,'a',3,4000)
insert into test values(1,'a',4,5000)
insert into test values(2,'b',1,3000)
insert into test values(2,'b',2,3500)
insert into test values(2,'b',3,4200)
insert into test values(2,'b',4,5500)
select * from
test --创建表test
现在需要把quarter 从1列数据变成4列数据 效果如: