摘要：
0.删除重复的数据 没有主键的delete from imp_comid awhere a.idcard || '%'|| a.driverid in (select a1 || '%'|| B1 from (select t.idcard a1,min(driverid) b1 from imp_comid t group by t.idcard having count(*)>1)) 1. update imp_stratwork t set t.class=1 ,t.guid = (select i.drivid from imp_driv_id i 阅读全文