分隔并分组在列中 [英] Seperate and group in a column

问题描述

嗨 我有这张桌子

---------
ID |名称
--------
1 |大卫是男人
2 |扬很感兴趣
3 |朱莉是女性
1 |麦克很好
---------

我想从桌子上拿起这张桌子:

---------
ID |名称
--------
1 |大卫是个男人-迈克是个好人
2 |扬很感兴趣
3 |朱莉是女性
---------

请指导我...

解决方案

尝试一下.

  SELECT  ID， LEFT ([[Name]，LEN([Name] )- 1 ) as  [名称]
             FROM ( SELECT   DISTINCT  ID
                        FROM 表名) AS  A

 外部 应用( SELECT  RTRIM(B.名称)+ ' -'
                  FROM 表名B  WHERE  A.ID = B.ID
                   FOR  XML PATH(' ')))  AS  C([名称])

hi i have this table

---------
ID | Name
--------
1 | David is a men
2 | Jan is interest
3 | Juli is a women
1 | Mike is good
---------

i wanna get this table from up table :

---------
ID | Name
--------
1 | David is a men -- Mike is good
2 | Jan is interest
3 | Juli is a women
---------

please guide me ...

解决方案

Try this.

SELECT   ID, LEFT([Name], LEN([Name]) - 1) as [Name]
            FROM  ( SELECT  DISTINCT ID 
                       FROM  tablename )  AS A
	          
 OUTER APPLY ( SELECT  RTRIM(B.Name)  + ' -- '
                 FROM  tablename B WHERE A.ID = B.ID 
                  FOR  XML PATH('') ) AS C ([Name])

这篇关于分隔并分组在列中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！