求购SQL语句

[taia]

areaid areaname
1 合肥市
1 合肥市
2 芜湖市
2 芜湖市
4 北京市
4 北京市
6 安庆市
6 安庆市
7 巢湖市
7 巢湖市

怎样删除其中重复的另一条记录使之成为如下:

areaid areaname
1 合肥市
2 芜湖市
4 北京市
6 安庆市
7 巢湖市

[taia]

g

[Andy__Huang]

用臨時表過渡數據﹐轉換數據完后再刪除臨時表

select distinct * into tab from tb
delete from tb
insert into tb select * from tab
drop table tb

[zlp321002]

恩。可以!

[ORARichard]

支持hdhai9451(※★開拓者...前進☆※)

楼主求购SQL，是付现金还是分分哦，（呵呵，开玩笑的）

[duanduan1122]

改动一下：
select distinct * into #tab from tb
go
delete from tb
go
insert into tb select * from #tab

[Ncaidexiaoniao]

create table aa(areaid int , areaname varchar(100))
insert aa select 1,'合肥市'
union all select 1,'合肥市'
union all select 2,'芜湖市'
union all select 2,'芜湖市'
union all select 4,'北京市'
union all select 4,'北京市'
union all select 6,'安庆市'
union all select 6,'安庆市'
union all select 7,'巢湖市'
union all select 7,'巢湖市'

select distinct * into #bb from aa
delete from aa
select * from #bb
drop table aa
drop table #bb

[davorsuker39]

select distinct * into #tab from tb
go
delete from tb
go
insert into tb select * from #tab