现有数据如下:
用一个SQL查询出每种角色有几个用户,把他们的id用逗号隔开放到一个字段里
select distinct b.rol_id,(
select stuff(
(select ','+a.ope_id from operator a where a.rol_id=b.rol_id FOR XML PATH(''))
,1,1,'') as ope_ids) as ope_ids
from operator b
结果就出来了。
现有数据如下:
用一个SQL查询出每种角色有几个用户,把他们的id用逗号隔开放到一个字段里
select distinct b.rol_id,(
select stuff(
(select ','+a.ope_id from operator a where a.rol_id=b.rol_id FOR XML PATH(''))
,1,1,'') as ope_ids) as ope_ids
from operator b
结果就出来了。