如何在SQL中将行变成列-解网

问：

我有这张桌子

SELECT PolicyID, ItemID, Period, Inventory1, Inventory2 
FROM tblInventory

我想将此表转换为：

该期间将转换为列，例如 Inventory1 -1 和 Inventory2 -1，直到第 4 个期间，每个期间包括两列：inventory1 和 inventory2。

我想请帮助了解如何在 SQL 中对此进行编码。谢谢！

sql-server

SELECT
    *
FROM
    (
        SELECT
            UP.PolicyId
            , UP.ItemId
            , CONCAT(UP.Inventories, '-', UP.Period) AS Inventories
            , UP.Inventory
        FROM
            tblInventory AS TI
        UNPIVOT
            (
                Inventory FOR Inventories IN (Inventory1, Inventory2)
            ) AS UP
    ) AS UNP
    PIVOT
    (
        MAX(Inventory)
        FOR Inventories IN 
            (
                [Inventory1-1], [Inventory1-2], [Inventory1-3], [Inventory1-4]
                , [Inventory2-1], [Inventory2-2], [Inventory2-3], [Inventory2-4]
            )
    ) AS PVT

上一个：Vb.net 函数不返回 SQL Server 存储过程结果

下一个：Listview （asp.net）中的 Datepicker（Jquery），代码隐藏（vb.net）

如何在SQL中将行变成列

How to make rows into columns in SQL

评论