删除重复数据

delete from kjt_xzdw a where rowid>(select min(rowid) from kjt_xzdw b where a.xzdm=b.xzdm);