SQL Server SQL convert column into

14ifxucb 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(84)

I have a table like below in SQL Server 2010

But I need an output like below

Please help me to solve, I need a select statement like how we are using pivot in Excel.

sql-server

来源：https://stackoverflow.com/questions/76751666/sql-convert-column-into

1条答案

按热度按时间

snvhrwxg1#

You can use Pivot table as :

SELECT [ID], [Data1] AS [Type1], [Data2] AS [Type2], [Data3] AS [Type3], [Data4] AS [Type4]
FROM (
    SELECT [ID], [Type], [Data]
    FROM table1
) AS SourceTable
PIVOT (
    MAX([Data])
    FOR [Type] IN ([Data1], [Data2], [Data3], [Data4])
) AS PivotTable;

I hope this will help you!!

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server SQL convert column into

1条答案

相关问题

热门标签

最新问答