Question

Sql语句查询问题，如何将横排的数据变为竖排

表A
PartNO Year Jan Feb Mar Apr
P001 2012 120 30 40 50

变成
PartNO Year Month QTY
P001 2012 Jan 120
P001 2012 Feb 30
P001 2012 Mar 40
P001 2012 Apr 50

Answer 1

select*from
(
select PartNO , Year,Month='Jan' , Result = Jan from tb1
unionall
select PartNO , Year,Month ='Feb' , Result = Feb from tb1
unionall
select PartNO , Year,Month='Mar' , Result = Mar from tb1
) t
orderby PartNO, case Month when'Jan' then1when'Feb'then 2 when'Mar' then3 end

Answer 2

你在百度搜索行列转化 会有很多实例，你看着改就行