where子句方法
select a.user_name, b.timestr, b.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) as cnt from user_kills group by user_id);
SQL开发技巧
标签：
SQL开发技巧
a.user_name, b.timestr, b.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