select col1, col2 = stuff(( select '、' + col2 from t where col1 = a.col1 for xml path('') ), 1, 1, '') from t a group by a.col1
转载于:https://www.cnblogs.com/zhaoguihua/articles/2380024.html
select col1, col2 = stuff(( select '、' + col2 from t where col1 = a.col1 for xml path('') ), 1, 1, '') from t a group by a.col1
转载于:https://www.cnblogs.com/zhaoguihua/articles/2380024.html