先创建表 create table cat (catId int , catName varchar(10)) 添加数据 insert into cat values(1,aa) 重复添加 select distinct * into temp from cat delete from cat insert into cat from temp drop table temp
SQL SERVER 如何删除重复记录
原文：http://7929163.blog.51cto.com/7919163/1668675
