表的内容:
使用PIVOT 语句:
1 select [ subject ] , [ 张三 ] , [ 李四 ] from (
2 select [ subject ] ,name,val from #PIVOT
3 ) as p1
4 pivot ( max (val) for name in ( [ 张三 ] , [ 李四 ] )) as p2
5 order by p2. [ subject ]
运行结果:
表内容:
UNPIVOT语句:
1 SELECT VendorID, Employee, Orders
2 FROM
3 ( SELECT VendorID, Emp1, Emp2, Emp3, Emp4, Emp5
4 FROM #pvt) p
5 UNPIVOT
6 (Orders FOR Employee IN
7 (Emp1, Emp2, Emp3, Emp4, Emp5)
8 ) AS ss;
运行结果: