求LINQ语句

ymc_cmy 2017-07-24 10:44:51

 id                  tel   

1001              13332434578

1002              13332434578

1003              15940166185

1005              13332434578

1004              15940166185

1009              13258741568

根据电话分组，得到

        id                                   tel

1001,1002,1005             13332434578

1003,1004                       15940166185

1009                                  13258741568

...全文

159 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

q107770540 2017-07-25

打赏
举报

This is very simple GroupBy

正怒月神 2017-07-24

打赏
举报

SELECT B.tel,LEFT(StuList,LEN(StuList)-1) as id FROM (
SELECT tel,
(SELECT id+',' FROM [Test] 
  WHERE tel=A.tel 
  FOR XML PATH('')) AS StuList
FROM [Test] A 
GROUP BY tel
) B