Oracle根据ROWID去重

例子:

DELETE FROM 表 A
 WHERE ROWID IN (SELECT ROWID_
                   FROM (SELECT 字段1,
字段2, ROWID ROWID_, ROW_NUMBER() OVER(PARTITION BY 字段1,字段2 ORDER BY
1) ROW_NUM FROM A) WHERE ROW_NUM > 1);

 

posted @ 2020-10-29 17:09  小窝蜗  阅读(369)  评论(0编辑  收藏  举报