oracle去重

1.oracle查找表中的重复数据

   select testid,count(1)
   from table
   group by testid
   having count(1)>1；
   testid 标签号

2.去重

   detele from tab_name a
   where col1,col2 in(
                                select col1,
                                col2
                                from tab_name
                                group by col1,col2
                                having count(*)>1);