求每個分組中的前N條記錄在LeetCode中的數據庫題目中已經是難度為Hard級別了,可以參考我的博客實現:http://blog.csdn.net/wzy_1988/article/details/52871636
2016-10-23
我用自己寫的也可以查出來
select a.name,b.kill_date,MAX(b.kill_num) max_kill
from `user` a join `kill` b ON a.id=b.user_id
GROUP BY a.name;
select a.name,b.kill_date,MAX(b.kill_num) max_kill
from `user` a join `kill` b ON a.id=b.user_id
GROUP BY a.name;
2016-09-29