MySQL开发技巧（三）3-5 [MySQL] 使用Group by 实现多属性查询

select a.user_name
from user1 a join user1_skills b on b.user_id = a.id
where b.skill in ('念经','变化','腾云','浮水',) and b.skill_level>0
group by a.user_name having couint(*)>=2
;

转载于:https://my.oschina.net/u/3430557/blog/1029907