ITeye博客

Oracle 中删除多条一样的数据

mywebcode · 2010-06-29 11:56 · Markdown

delete abc where (c1,c2,c3) in (select c1,c2,c3 from abc group by c1,c2,c3 having count(*)>1) and rowid not in
(select min(rowid) from abc group by c1,c2,c3 having count(*)>1);

Oracle 中删除多条一样的数据(只剩下一条数据,根据伪列查询);

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。