如何去掉表中重复的数据行?

[feiery]

我有一个表,结构如下:

Name ID Role
------ --- -----
zhang 23 developer
zhang 23 developer
Li 24 developer
Li 24 developer
Li 24 developer
wang 26 Manager

表在建的时候没有设primary key,所以表里有很多重复的数据行,现在要去掉重复的数据行,要怎么做呢?谁能给点建议?最好给个代码,谢过了,先!!

[wynlc]

[Quote=引用 1 楼 liangCK 的回复:]
SQL codeselect distinct * into # from tb
truncate table tb
insert into tb
select * from #
drop table #
[/Quote]

学习

[wzy_love_sly]

[Quote=引用 4 楼 bqb 的回复:]
SQL codeselectdistinct*intotmpfromtbdeletefromtb
sp_rename'tmp','tb'
[/Quote]
不错

[ojuju10]

select distinct Name , ID , Role from tab

[liangCK]

select distinct * into # from tb
truncate table tb
insert into tb
  select * from #
drop table #

[dawugui]

[Quote=引用楼主 feiery 的帖子:]
我有一个表,结构如下:

Name ID Role
------ --- -----
zhang 23 developer
zhang 23 developer
Li 24 developer
Li 24 developer
Li 24 developer
wang 26 Manager

表在建的时候没有设primary key,所以表里有很多重复的数据行,现在要去掉重复的数据行,要怎么做呢?谁能给点建议?最好给个代码,谢过了,先!!
[/Quote]
select distinct * into tmp from tb
delete from tb
insert into tb select * from tmp
drop table tmp

[-狙击手-]

select distinct * into # from tb
truncate table tb
insert into tb
  select * from #
drop table #

[bqb]

select distinct * into tmp from tb 
delete from tb 
sp_rename 'tmp','tb'