又是老问题，我忘了 *》_《* “如何删除重复的记录”,一条SQL语句

[newlife]

[yonge]

select distinct * from table

[newlife]

大哥，是删除 不 是过滤，？？

[tripofdream]

select distinct * from table1 into table2
drop table1

[amay]

delete tabName where sField not exists (select distinct * from tabName)

[powderbun]

能有这样一句话吗？
delete member_buyreproom where tt=member & repid not in(select distinct tt=member &repid from member_buyreproom)

我的想法是两个字段绑成一个关键字，重复的都删掉，但实现不了

[liugys]

delete member,buyreproom where tt=member and tt=repid not in(select distinct * from member,buyreproom where tt=member and tt=repid)

你查查ＳＱＬ语法手册吧。

[neweb]

重复的记录是不能删除和更新的，加一个自动编号的字段再删吧：
alter table tb_name add MyID int identity(1,1)