56,687
社区成员
发帖
与我相关
我的任务
分享
select a,min(b) b,c from table group by a,c having count(*) >1
select a,min(b) b,c from table force index(索引名) group by a,c having count(*) >1
select a,min(b) b,c from table group by a,c
alter table table add index (a,c);
alter table table add index (a,b,c);