我在Oracle中是这样做的不知在SqlServer中行不行请参考:
以Emp表为例(Empno是唯一字段):
DELETE Emp WHERE ROWID <> (
SELECT MAX(ROWID) FROM Emp E WHERE Emp.Empno = E.Empno);
即可删除Emp表中Empno重复的数据而只留下一条。
如果唯一条件是多个字段将字段并在WHERE条件后即可。
You can chang one of the value of the columns that have same value, then
delete one of it.But you must write some code to reach it.I think you can do it.