SELECT
ID,
Names = (stuff (( SELECT ',' + Name FROM Table a where a.ID=b.ID
FOR XML path ( '' ) ),1,1,''))
FROM
Table b group by Id
在Sqlserver中用for xml path替代 Oracle中 wm_concat函数
最新推荐文章于 2021-04-04 18:48:52 发布
SELECT
ID,
Names = (stuff (( SELECT ',' + Name FROM Table a where a.ID=b.ID
FOR XML path ( '' ) ),1,1,''))
FROM
Table b group by Id