错误示范:
select t.* from (
select * from error_record e order by e.begin_time desc
) t group by t.error_type
正确示范:
内部子查询用limit字段,可固定排序
select t.* from (
select * from error_record e order by e.begin_time desc limit 1000
) t group by t.error_type
原因:group by 之后mysql会默认根据id排序 所以导致指定排序失效