以下是查询重复数据的SQL语句：
select * from table1 where column1 in (select column1 from table1 group by column1 having count(*)>1);