Mysql5.7先排序order by 后 group by,但是排序不生效
pren 发布于 2021-11-22
经常会遇到需要对数据先排序后分组的情况,正常情况下执行下面的SQL便可以 SELECT * from (SELECT * FROM `jr_interview_operation` WHERE ( `interview_id` = 26 AND `type` = 3 ) AND ...
阅读(2462)评论(0)赞 (5)
pren 发布于 2021-11-22
经常会遇到需要对数据先排序后分组的情况,正常情况下执行下面的SQL便可以 SELECT * from (SELECT * FROM `jr_interview_operation` WHERE ( `interview_id` = 26 AND `type` = 3 ) AND ...
阅读(2462)评论(0)赞 (5)