Oracle 删除表中重复行

delete from qb_cbxx where rowid not in (select max(rowid) from qb_cbxx where sjly='情报报送' and del='false' group by (rwid,stxx))

原文地址:https://www.cnblogs.com/chai-blogs/p/6527057.html