SQL：列转行

最新推荐文章于 2024-10-22 15:59:55 发布

iteye_15971

最新推荐文章于 2024-10-22 15:59:55 发布

阅读量233

点赞数 1

分类专栏： sql

本文链接：https://blog.csdn.net/iteye_15971/article/details/82681748

版权

sql 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

CREATE TABLE #t(  
----[PKID] int primary key identity(101,1),  
    [iyear] [Nvarchar](4) NOT NULL,  
    [budget1] [int] NOT NULL,  
    [budget2] [int] NOT NULL,  
    [budget3] [int] Not Null  
    )  
GO  
INSERT #t  
SELECT '2016',100000,12676575,3623232
GO  
SELECT * FROM #t 

SELECT iyear as 年份,replace(bm,'budget','') as 月份,budget as 预算 
FROM  #t  
UNPIVOT(budget FOR bm IN (budget1,budget2,budget3) ) p

结果：