Oracle 删除表中重复行

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