mysql 先排序，后分组，不用子查询有别的办法吗
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`
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`
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
