1、 新建一张最简单的表，id自增长
2、 在表中插入重复值
3、 新建视图，首先要确定你的删除规则是什么样的，删除编号id比较大的还是比较小的
SELECT [1].id, [1].name, [2].id AS id2, [2].name AS name2
FROM dbo.repeat AS [1] INNER JOIN
dbo.repeat AS [2] ON [1].name = [2].name AND [1].id > [2].id
4、delete repeat
where id in (
SELECT [1].id
FROM dbo.repeat AS [1] INNER JOIN
dbo.repeat AS [2] ON [1].name = [2].name AND [1].id > [2].id
)
将视图select语句粘贴到删除语句后面，执行删除语句
5、 查看删除后结果，完成
