select ID,
STUFF((select ',' + name from class where ID = a.ID for xml path('')),1,1,'') as names --这个函数
from class a group by ID
SQL SERVER GROUP BY 字符串拼接
最新推荐文章于 2024-05-16 22:38:57 发布
select ID,
STUFF((select ',' + name from class where ID = a.ID for xml path('')),1,1,'') as names --这个函数
from class a group by ID