摘要： 删除表zfid,zsyj,zsbz重复记录中delete from yz_zfswxx where id not in(select id from yz_zfswxx where id in (select min(id) from yz_zfswxx group by zfid,zsyj,zsbz having count(zfid)>=1)) 阅读全文