MySQL先排序后分组（order by first then group by）

最新推荐文章于 2023-06-27 22:26:11 发布

iteye_15162

最新推荐文章于 2023-06-27 22:26:11 发布

阅读量349

点赞数

分类专栏： MySQL 文章标签： MySQL

本文链接：https://blog.csdn.net/iteye_15162/article/details/81995680

版权

MySQL 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

SELECT * FROM (SELECT * FROM result r WHERE r.activity_id = 2 ORDER BY r.score DESC,r.elapsed_time,r.play_time) t
GROUP BY t.player ORDER BY t.score DESC,t.elapsed_time,t.play_time;

优惠劵

iteye_15162

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MySQL先排序后分组（order by first then group by）

SELECT * FROM (SELECT * FROM result r WHERE r.activity_id = 2 ORDER BY r.score DESC,r.elapsed_time,r.play_time) tGROUP BY t.player ORDER BY t.score DESC,t.elapsed_time,t.play_time;
复制链接

扫一扫