用SQL语句，按B字段的值，重复的记录只显示一条，其他重复的为空

[sun429617116]

现在在数据库中有张表各条记录如上图，并且f 字段的个数不定，有三个、四个或五个选项；
现在想将记录放置成，如下图的方式，


这张表的数据有很多，是sql 2008数据库 ，请高手指点下、

[足球不是方的]

直接用excl简单些啊，汇总单元格

[Ginnnnnnnn]

SELECT CASE WHEN a.RNr = 1 THEN  A ELSE '' end,
		CASE WHEN a.RNr = 1 THEN  B ELSE '' end,
		CASE WHEN a.RNr = 1 THEN  C ELSE '' end,
		CASE WHEN a.RNr = 1 THEN  D ELSE '' end,
		E,F,G
	FROM (SELECT *,ROW_NUMBER() OVER (PARTITION BY A,B,C,D,E ORDER BY (SELECT 1)) AS RNr FROM Taba a) a

[sun429617116]

引用 2 楼 KanzakiOrange 的回复:

SELECT CASE WHEN a.RNr = 1 THEN  A ELSE '' end,
		CASE WHEN a.RNr = 1 THEN  B ELSE '' end,
		CASE WHEN a.RNr = 1 THEN  C ELSE '' end,
		CASE WHEN a.RNr = 1 THEN  D ELSE '' end,
		E,F,G
	FROM (SELECT *,ROW_NUMBER() OVER (PARTITION BY A,B,C,D,E ORDER BY (SELECT 1)) AS RNr FROM Taba a) a

谢谢