22,209
社区成员
发帖
与我相关
我的任务
分享
select
id,
crank=stuff((select '/'+crank from tb t where id=tb.id for xml path('')), 1, 1, '')
from
tb
group by
id
select
id,
crank=stuff((select ','+[crank] from tb t where id=tb.id for xml path('')), 1, 1, '')
from
tb
group by
id