合并重复 

select UId,UName,stuff((select ','+RName from USER_SHOW where a.UId = UId for xml path('')),1,1,'') as RName from USER_SHOW as a group by UId,UName
posted @ 2020-01-12 10:59  噜啦啦0001  阅读(84)  评论(0)  编辑  收藏  举报