Oracle remove duplicate

DELETE FROM your_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM your_table
GROUP BY column1, column2, column3);
posted @ 2018-04-27 11:09  kakaisgood  阅读(167)  评论(0编辑  收藏  举报