求一sql语句....

[yuranccc2003]

数据库中有完全相同的两条记录，怎样删除一条留下一条？
如果不行,就都删除吧。

[rivery]

select distinct col1,col2 into #t from tablename
delete from tablename
insert into tablename from #t
drop table #t

[凨叔]

可以
select * into #temp from table1
delete from table1
insert into table1 select * from #temp

[凨叔]

select distinct * into #temp from table1
delete from table1
insert into table1 select * from #temp
drop table #temp

[hsj20041004]

如果有id

delete from tablename a where exists(select * from tablename where a.id<id and a.col1=col1)


如果没有id
alter table tablename add id int identity(1,1)
delete from tablename a where exists(select * from tablename where a.id<id and a.col1=col1)
alter table tablename drop column id


-----
select distinct * into #t from 原表
truncate table 原表
insert into 原表 select * from #t
drop table #t