将行转换为SQL Server中的列 [英] Convert rows to columns in SQL server

问题描述

大家好，



i要求在SQL服务器中将行转换为列。



i已检索如下数据：

Hi All,

i have requirement like to Convert rows to columns in SQL server.

i have retrieved data like below:

MatchId SelectionName   Odds
322	Home Win	1.33
322	Draw	        5.00
322	Away Win	9.00
322	Under 2.5	2.40
322	Over 2.5	1.53

和wan转换如下：

and want to convert like below:

MatchId Home Win   Draw   Away Win   Under 2.5   Over 2.5
322	1.33	   5.00   9.00       2.40        1.53 

我该怎么做？



谢谢，

KK

how can i do this?

Thanks,
KK

推荐答案

Select MatchId,[Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5]
From TableName 
PIVOT
( 
    SUM(Odds) For SelectionName in ([Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5])
) as pvttbl

快乐编码！

：）

Happy Coding!
:)

查询for ms sql server 中的列成行[ ^ ]







使用此..如果y你有任何疑问请告诉我..我会帮你..

query for make columns into rows in ms sql server[^]



use this.. If you have any query Please let me know.. i will help you..

你好，



i从下面得到了我的结果查询。

Hello,

i got my result from below query.

select * from (select MatchId,SelectionName,Odds From
    #tmpMatchOdds) As P Pivot
    (
        Sum([odds]) For SelectionName In ([Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5])
    )As pv

感谢您的回复。

Thanks for reply.

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