如何在sqlserver中显示为pivot [英] How show as pivot in sqlserver

问题描述

我有一张桌子包含



SID | RId | FID |费用

41 | 1 | 1 | 100

41 | 1 | 2 | 200

41 | 1 | 3 | 300

41 | 1 | 4 | 400



我想展示像



SID | RID | 1 | 2 | 3 | 4 |

41 | 1 | 100 | 200 | 300 | 400 |



plz help



我的尝试：



..............................

解决方案

尝试：

  SELECT  * 
 < span class =code-keyword> FROM （ SELECT  SID，RID，FID，FEE  FROM  MyTable）
 PIVOT（
 SUM（FEE）
  FOR  FID  in （[ 1 ]，[ 2 ]，[ 3 ]，[ 4 ]）
） AS  x 

I have a table that is containing

SID | RId | FID | Fee
41 | 1 | 1 | 100
41 | 1 | 2 | 200
41 | 1 | 3 | 300
41 | 1 | 4 | 400

I want to show like

SID | RID | 1 | 2 | 3 | 4 |
41 | 1 | 100 |200 | 300 | 400 |

plz help

What I have tried:

..............................

解决方案

Try:

SELECT *
FROM (SELECT SID, RID, FID, FEE FROM MyTable) a
PIVOT (
   SUM(FEE)
   FOR FID in ([1], [2], [3], [4]) 
) AS x

这篇关于如何在sqlserver中显示为pivot的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！