摘要: 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 阅读全文
posted @ 2011-04-17 15:50 Look_Sun 阅读(264) 评论(0) 推荐(0) 编辑