有一个表里面有某个字段出现重复记录,怎样保留重复记录中的第一条记录
2007-11-28 18:41:18 来源:WEB开发网核心提示:有一个表里面有某个字段出现重复记录,怎样保留重复记录中的第一条记录select *,identity(int,1,1) ID into #t1 from table1 delete a from #t1 a where ID > (select min(ID) from #t1 where field
有一个表里面有某个字段出现重复记录,怎样保留重复记录中的第一条记录
select *,identity(int,1,1) ID into #t1 from table1
delete a
from #t1 a
where ID > (select min(ID) from #t1 where field1=a.field1 and
field2=a.field2 and ... fieldn=a.fieldn)
trancate table table1
alter table #t1 drop column ID
insert into table1 select * from #t1
也许可以这样,简便些
select distinct * into #t1 from table1
trancate table table1
insert into table1 select * from #t1
更多精彩
赞助商链接