MySQL开发技巧（三）2-2 [MySQL] 如何在子查询中实现多例过滤

elect user_id,max(kills) as cnt from user_kills group by user_id;

select a.user_name,b.timestr,kills
from user1 a join user_kills b on a.id =b.user_id
join (select user_id,max(kills) as cnt from user_kills group by user_id)
c on b.user_id=c.user_id and b.kills = c.cnt;

select a.user_name,b.timestr,kills from user1 a join user_kills b on a.id=b.user_id where (b.user_id,b.kills) in (select user_id,max(kills)from user_kills group by user_id);

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