查询重复数据的SQL语句 select column1, column2 from TB where column1 in (select column1, column2 from TB group by column1, column2having(count(*)>1))