没有看明白你的详细意思,不过按照我的理解。假如是删除两条记录的其中一条的话,你可以这样:delete from ( select *,ps=row_number()over(order by getdate()) from table where id='重复记录的那个id' ) a where a.ps=2
delete from ( select *,ps=row_number()over(order by getdate()) from tablewhere id='重复记录的那个id') a where a.ps<>1删除多条重复,只留下一条
(
select *,ps=row_number()over(order by getdate())
from table
where id='重复记录的那个id'
) a
where a.ps=2
name age
test 22
test 22
delete from tablename
insert into tablename select * from temp
drop table tableName
select * into tableName from #Tmp
drop table #Tmp1