oracle去重重复行

select sum(count(1))-count(1) from  table group by  id having count(1)>1
​​​​​​​--查询重复行数

 

select count(1)
from table
where _id in (select _id
              from table
              group by _id
              having count(*) > 1)
  and rowid not in
      (select min(rowid)
       from table
       group by _id
       having count(*) > 1);
--查询 去重条数

delete from table
where _id in (select _id
              from table
              group by _id
              having count(*) > 1)
  and rowid not in
      (select min(rowid)
       from table
       group by _id
       having count(*) > 1);
--删除重复数据