ORACLE中查询重复记录

select   *   from   table1  
  where   col2   in  
  (   select   disctinct   col2   from   table1   group   by   col2   having   count(col2)>1)