SELECT * FROM (SELECT * from table where isDel = 0 ORDER BY createTime DESC limit 10) t GROUP BY id ;
注意,需要加limit ,否则语句不会生效
评论解答:
从mysql5.7开始,子查询的排序已经变为无效了。所以要加个limit,这样子查询就不光是排序,所以此时排序会生效,但有条数限制10000
SELECT * FROM (SELECT * from table where isDel = 0 ORDER BY createTime DESC limit 10) t GROUP BY id ;
注意,需要加limit ,否则语句不会生效
评论解答:
从mysql5.7开始,子查询的排序已经变为无效了。所以要加个limit,这样子查询就不光是排序,所以此时排序会生效,但有条数限制10000