查找重复数据?解决办法

--如果是查询select distinct name from temp
------解决方案--------------------
SQL code
--如果是删除,将查询出来的数据放一临时表,清空原来的表,然后将数据从临时表中导回来select distinct name into test from tempdelete from tempinsert into temp select * from test
------解决方案--------------------
楼上正解。。。

select distinct name into test from temp
truncate table temp
insert into temp select * from test

------解决方案--------------------
1,若查找含有重复行的name
select name from tb group by name having count(*)>1

2,若查找重复name的记录,只保留一条
select distinct name into # name from tb
truncate table tb
insert tb select name from #
drop table #
------解决方案--------------------
--查找所有重复数据
select * from temp where name in (select name from temp group by name having count(name)>1)
要删除就是
select distinct name into test from temp
delete from temp
insert into temp select * from test


------解决方案--------------------
不是先group by 有用的字段然后用not in delete么
我想这个表应该有个主键的吧，我用id代替
delete from temp where id not in(select max(id),name from temp group by name )
------解决方案--------------------

select 'a' as [name] into #temp
insert into #temp  
select 'b'
union all  
select 'b'
union all  
select 'c'


delete from #temp where name in (select name from #temp group by name having count(name)>1)   --把这句中的#temp换成你自己的temp就可以了，其余的语句为测试语句  

select * from #temp
------解决方案--------------------
select distinct name into test from temp
truncate table temp
insert into temp select * from test
------解决方案--------------------
delete from table where name in(select name from table group by name having count(name)>1)
------解决方案--------------------
不含distinct的sql.
楼上的很好:
delete from table where name in(select name from table group by name having count(name) >1).