我想用一条语句将重复值删除,怎么写阿?帮帮我啊

[SnakeWOo]

我的数据有一条除主键外,全为0的重复值,要怎么写才将其删除阿?

[愉快的登山者]

delete * from tablename where 主键 = (那条全为0的记录主键）

[CrazyFor]

delect * from tablename where
col1=0 and col2=0 and col3=0 and .....

[mymmsc]

delete * from tablename where 主键 = (那条全为0的记录主键）

[happydreamer]

1）删掉重复的：
alter table 表 add newfield int identity(1,1)
delete 表
where newfield not in(
select min(newfield) from 表 group by 除newfield外的所有字段
)
alter table 表 drop column newfield


2）
DELETE L
FROM table L
JOIN table R
ON L.字段1 = R.字段1 AND L.id > R.id