怎么删除表中某一列重复的记录？感谢指导

[oldlizheng]

要删除表中name字段重复的记录
比如table1,有name,tel等字段，主键为id，自增int
有的记录的name是重复的，现在要删掉重复的，保留任意一个就可以了。

怎么写sql？或用程序实现

[rea1gz]

delete t
from table1 t
where exists (
select 1 from table1 where name=t.name and id>t.id)

[friendlyFour]

Delete(删除重复但保留重复记录中的第一条记录)
--方法一：
--建立測試環境
Create Table A
(id Int,
name Varchar(10),
age Int)
Insert A Select 1, 'w', 18
Union All Select 2, 'e', 17
Union All Select 3, 'w', 18
Union All Select 4, 'e', 17
Union All Select 5, 'e', 17
Union All Select 6, 'q', 16
--測試
Select * from A
Delete from A Where id Not In (Select Min(id) As id from A Group By name,age)
Select * from A
--刪除測試環境
Drop Table A
--結果
/*
--刪除前
idnameage
1w18
2e17
3w18
4e17
5e17
6q16

--刪除後
idnameage
1w18
2e17
6q16
*/

[冷箫轻笛]

--保留重复name中id最小的
delete t1 from table1 t1
where exists(select 1 from table1 where name = t1.name and id < t1.id)

[caixia615]

select distinct name,tel,id from table insert to newtable

[firein]

delete * from table1
where idnot in
(
select Min(id) from table1
group by name
)

[studenthj]

select distinct name,tel,id into b
from a

[Juchiyufei]

关注

[Juchiyufei]

感觉你们的问题都比我的要简单，我的问题怎么那么复杂呢？


郁闷呀。

[温飞_会员]

编程序吧!sql不能一次解决