ORACLE 删除重复行，保留一条记录SQL

最新推荐文章于 2021-04-10 13:55:18 发布

weixin_30570101

最新推荐文章于 2021-04-10 13:55:18 发布

阅读量96

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/huak/p/8334968.html

版权

    DELETE FROM cux_temp t
     WHERE t.name_id IN (
      SELECT c.name_id
        FROM cux_temp c
       GROUP BY c.name_id HAVING COUNT(c.name_id) > 1)
     AND ROWID NOT IN (
       SELECT min(c.rowid) row_id
         FROM cux_temp c
        GROUP BY c.name_id HAVING COUNT(c.name_id) > 1);