--查询一个表中有效去掉重复的记录,UserID为自增长主键,RoleID为重复字段
select MIN(UserID) as UserID, RoleID from tmpTable group by RoleID
select RoleID from tmpTable group by RoleID HAVING ( count(*) > 1)
select distinct * from tmpTable
--删除重复记录
select distinct * into #Tmp from tableName
drop table tableName
select * into tableName from #Tmp
drop table #Tmp
select MIN(UserID) as UserID, RoleID from tmpTable group by RoleID
select RoleID from tmpTable group by RoleID HAVING ( count(*) > 1)
select distinct * from tmpTable
--删除重复记录
select distinct * into #Tmp from tableName
drop table tableName
select * into tableName from #Tmp
drop table #Tmp