– 从mysql5.7开始,子查询的排序已经变为无效了。所以要加个limit,这样子查询就不光是排序,所以此时排序会生效,但有条数限制10000
SELECT
*
FROM
( SELECT * FROM tableName
ORDER BY create_time
DESC limit 10000 ) tmp
GROUP BY
tmp.field
– 从mysql5.7开始,子查询的排序已经变为无效了。所以要加个limit,这样子查询就不光是排序,所以此时排序会生效,但有条数限制10000
SELECT
*
FROM
( SELECT * FROM tableName
ORDER BY create_time
DESC limit 10000 ) tmp
GROUP BY
tmp.field