SQL Server实现group by 之后 聚合操作之拼接结果
使用 stuff函数
select field1, stuff((select ','+field2 from table t where l_id in (1,2,3,4,5,6,7,8,9) and t.l_id=s.l_id for xml path('')), 1, 1, '') field2
from table s where l_id in (1,2,3,4,5,6,7,8,9)
group by l_id
使用 stuff函数
select field1, stuff((select ','+field2 from table t where l_id in (1,2,3,4,5,6,7,8,9) and t.l_id=s.l_id for xml path('')), 1, 1, '') field2
from table s where l_id in (1,2,3,4,5,6,7,8,9)
group by l_id
