sql如下: select column1,column2,count(*) from tableName group by column1,column2 having count(*)>1 order by count(*) desc