删除表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)
)
删除表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)
)
转载于:https://www.cnblogs.com/WhiteCloud/archive/2008/09/02/1282191.html