mysql 先排序，后分组，不用子查询有别的办法吗

Question

如题所述

Answer 1

额 联合查询 + 临时表 也可以 效率貌似更低
select T1.* from T1

left outer join (select * from T1 order by `key` desc limit 0,100) as tempTable
on T1.id = tempTable.id
group by `key`

直接用临时表 也可以
select * from (select * T1 order by `key` limit 0,1000) as tempTable group by `key`