如何统计平台中有角色的用户数
select count(distinct a.suername )用户数 from fine_user a
left join
fine_user_role_middle b
on a.id=b.userid
left join fine_dep_role c
on b.roleid=c.id
left join fine_department d
on c.departmentid=d.id
left join fine_custom_role e
on b.roleid=e.id
where e.name is not null
1min目标场景问卷
立即参与
