SqlServer 将查询出的多行数据拼成一个字符串返回
SELECT main_id,main_name,
main_hobby=STUFF((SELECT ','+sub_hobby FROM
table_sub WHERE main_id=t.main_id FOR XML PATH('')),1,1,'')
FROM table_main t
GROUP BY main_id,main_name
stuff(select ',' +...
原创
2018-10-23 16:09:29 ·
3222 阅读 ·
0 评论