exists和in异同
先看例子:select * from role r where roleId in(select roleId from user)select * from role r where roleId exists(select roleId from user where userId=r.roleId)这里用in或者exists,最后结果是一样的,都是列出user表中存在
