id name sex nation mapinfo dress
3 陈冬生 男 NULL 30.636841,104.086533 南新街25号1栋1单元11号
3 陈冬生 男 NULL 30.636841,104.086533 南新街25号1栋1单元11号
3 陈冬生 男 NULL 30.636841,104.086533 南新街25号1栋1单元11号
3 陈冬生 男 NULL 30.636841,104.086533 南新街25号1栋1单元11号
这个是表名oldpersoninfo
select distinct * into #t from tb
truncate table tb
insert into tb select * from #t
drop table tb
select distinct * into #t from tb
delete from tb -- truncate 不产生LOG,建议用delete
insert into tb select * from #t
drop table tb
DELETE t FROM (SELECT *,row=ROW_NUMBER() OVER (PARTITION BY id ORDER BY GETDATE()) FROM oldpersoninfo)t
WHERE t.row>1