分组排序后取前20条数据

[qq_32504001]

mysql 数据库 对表进行了分组排序后，想取排序后的前20条如何取，我用limit 0,20报错

[benluobo]

贴出错误信息 以及查询语句

[qq_32504001]

select request_url,max(execution_time) ,min(execution_time),round(avg(execution_time),1),count( request_url),sum(execution_time)sum from apm_url_call group by request_url order by sum desc limit 0,20 错误 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0,100' at line 3

[benluobo]

你的语句是 limit 0,20 报错是 limit 0,100 是否截图出现问题？或者执行的语句本身就错了

[qq_32504001]

截图不知道为什么传不上去，语句本身没问题

[ACMAIN_CHM]

参考下贴中的多种方法 http://blog.csdn.net/acmain_chm/article/details/4126306 [征集]分组取最大N条记录方法征集，及散分....

[rick-he]

http://blog.csdn.net/u011575570/article/details/49953495