删除重复记录最高效的办法

delete from b_bk_jgcl e
where e.rowid>(select min(x.rowid)
from b_bk_jgcl x
where x.jlbh=e.jlbh);
commit;