怎么利用SQL语句查询数据库中具体某个字段的重复行

select * from tabel1 where filed01 in (select filed01 fromtabel1group by filed01having count(filed01 )>1)说明：filed01 为有重复字段的列