如何使用sql server pivot表 [英] how to use sql server pivot table
本文介绍了如何使用sql server pivot表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想实现以下场景
更改以下数据集
v1 1
v2 2
v3 3
to
v1 v2 v3
1 2 3
请帮助,我听说有一些数据透视表的东西,如果有任何教程请分享
解决方案
如果您只需要教程来实现SQL Pivot那么
点击这里 [ ^ ]
嗨朋友,
请查询以下答案。
< pre lang =SQL> CREATE TABLE #pvt
(
na < span class =code-keyword> varchar ( 5 ),
id int
)
INSERT INTO #pvt(na,id) VALUES (' v1', 1 ), (' v2', 2 ), (' v3', 3 )
SELECT * FROM #pvt
SELECT v1 AS [V1],v2 AS [ V2],v3 AS [V3] FROM
(
SELECT na,id FROM #pvt
)p
pivot
(
min(id)
FOR na in (v1 ,v2,v3)
) as pvt
i want to implement the following scenario
change the following dataset
v1 1
v2 2
v3 3
to
v1 v2 v3
1 2 3
please help, i heard there is some pivot table thing, please share if there is any tutorial
解决方案
if you just need the tutorial to implement SQL Pivot then
click here[^]
Hi Friend,
Please find the below answer for your query.
CREATE TABLE #pvt ( na varchar(5), id int ) INSERT INTO #pvt (na,id) VALUES('v1',1),('v2',2),('v3',3) SELECT * FROM #pvt SELECT v1 AS [V1],v2 AS [V2],v3 AS [V3] FROM ( SELECT na,id FROM #pvt )p pivot ( min(id) FOR na in (v1,v2,v3) )as pvt
这篇关于如何使用sql server pivot表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文