一张表里重复记录删除只剩一条怎么弄

[pursuade]

我有一张基本表
里面不同类别的重复记录有很多
我想把重复记录删除掉 不同类别的记录只剩一条怎么做

比如表aa
A B C
11 30 q
11 30 q
14 15 b
14 15 b
我要达到的目的是
A B C
11 30 q
14 15 b

[filebat]

把临时表改成表变量会更好一些.

游标，求最大值什么的就没有必要了吧！！！

[fishead37]

select * into #b from #aa group by a,b,c having count(*)>1 --把不止一条的复制到别的表中

delete from #aa where a in (
select a from #aa group by a,b,c having count(*)>1) --只删除重复记录，不重复的不删除


insert #aa --把重复，复制到原表中。
select * from #b group by a,b,c having count(*)>1

[flyorgao]

建议用临时表

[rivery]

select distinct * into #t
from aa
delete from aa
insert into aa
select *
from #t
drop table #t

[sasacat]

select distinct * into #tmp from aa
delete from aa
insert into aa select * from #tmp

[sunqi_790817]

select A,B,C into #tmp from aa group by A,B,C
drop table aa
select * into aa from #tmp
drop table #tmp

[YoungMonkey]

-- 查出唯一纪录生成临时表
SELECT DISTINCT * INTO #tmp FROM aa
-- 清空原表数据（数据量大建议用TRUNCATE TABLE，不写日志，速度快很多）
TRUNCATE TABLE aa
-- 导入处理后的数据
INSERT INTO aa SELECT * FROM #tmp

[建军黄]

先找出最大的重复数

然后用循环语句将重复纪录一条一条的删除

[GRLD8888]

如果表中数据不是很多的话，用游标也是可以的

[ahFaye]

支持临时表

[jiushaoye]

用临时表,一楼就可以.

[zzxiaoma]

select distinct * into #aa from 表

truncate table 表
insert into 表 select *from #aa