删除数据库表内重复数据，只保存一条

1首先新建一个相同的表BASE_ROLE1，执行下面语句，（随机取出一条重复数据）

INSERT INTO dbo.BASE_ROLE1

(ID, NAME, ROLE_SORT, XH, REMARK, STATE )
(select distinct A1.ID, 
(select top 1 A2.name from BASE_ROLE as A2 where A1.ID = A2.ID order by newid()) as NAME,
(select top 1 A2.ROLE_SORT from BASE_ROLE as A2 where A1.ID = A2.ID order by newid()) as ROLE_SORT,
(select top 1 A2.XH from BASE_ROLE as A2 where A1.ID = A2.ID order by newid()) as XH,
(select top 1 A2.REMARK from BASE_ROLE as A2 where A1.ID = A2.ID order by newid()) as REMARK,
(select top 1 A2.STATE from BASE_ROLE as A2 where A1.ID = A2.ID order by newid()) as STATE

from BASE_ROLE as A1) --其中BASE_ROLE为你表的名称

2删除原表数据BASE_ROLE

delete from BASE_ROLE

3将数据导回到原表

INSERT INTO dbo.BASE_ROLE
(ID, NAME, ROLE_SORT, XH, REMARK, STATE )
          (SELECT *  FROM dbo.BASE_ROLE1)