mysql中使用sql找出每组当中最大的那条数据

统计每组中平均执行时间最长的URL的数据

写法一：

select A.url,A.count,A.sumtime,A.avgtime,A.addtime from baas_system_log  Ainner join (select addtime, max(avgtime) as avgtime from baas_system_log  group by addtime) B on A.addtime=B.addtime AND A.avgtime=B.avgtime ;

写法二:

select url, count, sumtime, avgtime, addtime  from (select url, count,sumtime,avgtime,addtime, row_number() over(partition by addtime order by avgtime desc) row_num          from baas_system_log         group by url, count, sumtime, avgtime, addtime) tbrow where row_num = 1;