效果 :
原表: SELECT * FROM pvt
列转行:
SELECT * FROM pvt p UNPIVOT(
Orders FOR Employee IN (Emp1, Emp2, Emp3, Emp4, Emp5)
)AS unpvt;
效果 :
原表: SELECT * FROM pvt
列转行:
SELECT * FROM pvt p UNPIVOT(
Orders FOR Employee IN (Emp1, Emp2, Emp3, Emp4, Emp5)
)AS unpvt;