oracle 重复只保留一条

DELETE FROM xx WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM xx  GROUP BY xx, xx);
 

posted @ 2019-01-25 12:04  kakaisgood  阅读(333)  评论(0)  编辑  收藏  举报