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 tGROUP BY main_id,main_namestuff(select ',' +...
原创
2018-10-23 16:09:29 ·
3194 阅读 ·
0 评论