oracle中获取字段值存在重复的记录 select *from test1 where name =( select name from test1 group by name having count(*)> 1 )