删除表中多余的重复记录

删除表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)
)