试试这个查询：
SELECt * FROM records WHERe map = 'map1' and kills in (SELECt * FROM (select Kills from records where map = 'map1' group by Kills order by kills desc limit 0,5) as x) order by Kills desc
SQLFIDDLE
试试这个查询：
SELECt * FROM records WHERe map = 'map1' and kills in (SELECt * FROM (select Kills from records where map = 'map1' group by Kills order by kills desc limit 0,5) as x) order by Kills desc
SQLFIDDLE
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
