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  阅读(189)  评论(0)    收藏  举报