每个人打怪最多的两天
老师为什么还需要分组呢?? 分组有什么好处,我这 没有分组也得到同样的结果
select d.user_name ,c.timestr,kills
from (
select user_id,timestr,kills,(select count(*) from user_kills b
where b.user_id = a.user_id and a.kills <= b.kills) as cnt
from user_kills a
)c join user1 d on c.user_id = d.id
where cnt <= 2
这样会得到同样的结果,