oracle去重重复行

最新推荐文章于 2023-02-06 17:15:13 发布

原创最新推荐文章于 2023-02-06 17:15:13 发布 · 494 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

2 篇文章

订阅专栏

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);
--删除重复数据