删除dk_pic_reg中重复记录.txt

关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品

delete from dk_pic_reg a
where a.rowid != (select max(rowid) from dk_pic_reg b
where a.grzh=b.grzh and a.lb = b.lb)