199、 一个用户具有多个角色，请查询出该表中具有该用户的所有角色的其他用户。
199、 一个用户具有多个角色，请查询出该表中具有该用户的所有角色的其他用户。select count(*) as num,tb.id
from
tb,
(select role from tb where id=xxx) as t1
where
tb.role = t1.role and tb.id != t1.id
group by tb.id
having
num = select count(role) from tb where id=xxx;
页:
[1]