SQL中查询重复记录和删除重复记录

很郁闷的sql语句啊。其实仔细想也很简单。反正郁闷

表结构就是A,B,C3个字段
查询重复的记录
select count(*) ,A,B,C from test
group by A,B,C having count(*) > 1

删除重复的记录
select distinct * into #Tmp from test
drop table test
select * into test from #Tmp
drop table #Tmp