在sql中的列中转换行值 [英] Convert row value in column in sql

问题描述

先生我需要在列中转换行，先生我有1行超过40列我需要在列中显示它。先生，我读了一些文章相关的枢轴，但我无法理解。谢谢

Sir i need convert row in columns ,sir i have 1 row more than 40 column i need show it in as columns. sir i read some article related pivot but i couldn't understand. thanks

推荐答案

您需要使用Pivot将行转换为列 - SQL Server中的数据透视示例 [ ^ ] 。

You ahve to use Pivot to convert rows into columns - Pivot Example in SQL Server[^].

使用Pivot [ ^ ]



在SQL查询中使用Pivot的简单方法 [ ^ ]



以上两个链接可以帮到你。

请回复查询（如果有的话） />
谢谢

Using Pivot[^]

Simple Way To Use Pivot In SQL Query[^]

The above two links would help you.
Please post back queries if any.
Thanks

请在下面找到示例。

希望它能帮助你理解PIVOT

Please find below example.
Hope it would help you to understand PIVOT

CREATE TABLE #Product(Cust VARCHAR(25), Product VARCHAR(20), QTY INT)

-- Inserting Data into Table
INSERT INTO #Product(Cust, Product, QTY)
VALUES('KATE','VEG',2)
INSERT INTO #Product(Cust, Product, QTY)
VALUES('KATE','SODA',6)
INSERT INTO #Product(Cust, Product, QTY)
VALUES('KATE','MILK',1)
INSERT INTO #Product(Cust, Product, QTY)
VALUES('KATE','BEER',12)
INSERT INTO #Product(Cust, Product, QTY)
VALUES('FRED','MILK',3)
INSERT INTO #Product(Cust, Product, QTY)
VALUES('FRED','BEER',24)
INSERT INTO #Product(Cust, Product, QTY)
VALUES('KATE','VEG',3)

SELECT *
FROM #Product

--First Example : 
SELECT PRODUCT, FRED, KATE
FROM (
SELECT CUST, PRODUCT, QTY
FROM #Product) up
PIVOT (SUM(QTY) FOR CUST IN (FRED, KATE)) AS pvt
ORDER BY PRODUCT

--Second Example : 
SELECT CUST, VEG, SODA, MILK, BEER, CHIPS
FROM (
SELECT CUST, PRODUCT, QTY
FROM #Product) up
PIVOT (SUM(QTY) FOR PRODUCT IN (VEG, SODA, MILK, BEER, CHIPS)) AS pvt
ORDER BY CUST

这篇关于在sql中的列中转换行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！