1、先建了索引2、select a,b,count(*) c from table group by a,b into temp temp_table with no log3、select a,b,c from temp_table where c >1试试看
显示全部1、先建了索引
2、select a,b,count(*) c from table group by a,b into temp temp_table with no log
3、select a,b,c from temp_table where c >1
试试看
收起