sql server FOR XML PATH 字符串拼接

来源:互联网 发布:idg 知乎 编辑:程序博客网 时间:2024/05/01 09:27
SELECT B.sName,LEFT(StuList,LEN(StuList)-1) as hobby FROM (SELECT sName,(SELECT hobby+',' FROM student   WHERE sName=A.sName   FOR XML PATH('')) AS StuListFROM student A GROUP BY sName) B

0 0
原创粉丝点击