SQL在Group By之前Order By

stackoverflow: MySQL order by before group by

select a.* from (select * from b2c_user_card order by b2c_user_card.card_id desc ) as a  GROUP BY a.user_id

mysql5.7 先排序ORDER BY,后分组 GROUP BY

需要limit才生效，该博客的解释是

explain 查看执行计划，发现在没有 limit 的情况，会少了一个derived 操作,mysql会认为这时候不需要排序,内部做了优化,所以这种情况下加limit限制就可以了,如下(limt 后的行数 可以作为参数传入):

select a.