group by 不加limit语句会被自动优化干掉。
解决方案:
select * from (select * from message order by id desc limit 99999) tt group by conversation_id;
group by 不加limit语句会被自动优化干掉。
解决方案:
select * from (select * from message order by id desc limit 99999) tt group by conversation_id;