删除dk_pic_reg中重复记录.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 3 行

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)