sqlserver数据库行列转换(看看吧)

刚学到的行列转换:
create table orders

(

productId int identity primary key,

OrderMonth  int ,

SubTotal int

)

 

insert into orders values(5,45)

insert into orders values(6,95)

insert into orders values(7,58)

 

 

SELECT ProductID, [5] AS 五月, [6] AS 六月, [7] AS 七月
FROM
Orders PIVOT
(
SUM (SubTotal)
FOR OrderMonth IN
( [5], [6], [7] )
) AS pvt
这里用到一个关键字pivot，sqlserver2005以上的版本才支持这个关键字