mysql 先分组然后组内排序，之后取出前三个值
2020-03-16 本文已影响0人
韩小禹
image.png
SELECT a.* FROM ( SELECT t1.*,(SELECT count(*)+1 FROM qps_hour WHERE hour=t1.hour AND id<t1.id AND time="2020-03-15") AS g_id FROM qps_hour t1 WHERE t1.time="2020-03-15" ) AS a WHERE a.g_id<=3
image.png
