表结构
CREATE TABLE [dbo].[ST_MANYYEARS_DATA] (
[year] varchar(20) NULL ,
[JAN] varchar(20) NULL ,
[FEB] varchar(20) NULL ,
[MAR] varchar(20) NULL ,
[APR] varchar(20) NULL ,
[MAY] varchar(20) NULL ,
[JUN] varchar(20) NULL ,
[JUL] varchar(20) NULL ,
[AUG] varchar(20) NULL ,
[SEP] varchar(20) NULL ,
[OCT] varchar(20) NULL ,
[NOV] varchar(20) NULL ,
[DECE] varchar(20) NULL ,
[YEARS] varchar(20) NULL
)
行转列查询语句
SELECT year,tType=attribute,Num=value FROM (select * from ST_MANYYEARS_DATA)a UNPIVOT (value FOR attribute IN(JAN, FEB, MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DECE,YEARS) ) AS UPV
查询结果: