选出重复的行:
select * from t group by id, col2 having count(*)>1
删掉重复的行,
alter table t add col3 int identity not null;
delete from t where col3 not in (select max(col3) from t group by id, col2);
alter table t drop col3;(前提select into/bulkcopy on数据库上的options)