sql问题

[godidea]

表A

ID Name
1 mary
2 mary
3 bibi
4 wuji
5 qiqi
6 qiqi
7 qiqi
8 kaka
9 kaka


用什么sql语句可以变成

ID Name
1 mary
3 bibi
4 wuji
5 qiqi
8 kaka

[sdhdy]

select * from 表A where ID in (select min(id) from 表A group by Name)

[friendliu]

select distinct Name,ID from 表A
go

[dafu71]

select name, min(id) from 表A group by name

[aierong]

select min(id) as id,name from 表A
group by name

[yujohny]

用这个语句
select A.* from 表A A,表A B where A.name =B.name and A.ID <B.ID

[yujohny]

用这个语句：
select A.* from 表A A,表A B where A.name = B.name AND A.id <B.id

[junny1017]

同意无为的方法

[youhj]

同 无为
select distinct Name,ID from 表A

[dickmonkey]

select id,name from 表 group by name

[godidea]

没表达好，我的意思是把表物理删除重复的记录

[将计就计123]

select id=min(id),name from 表A group by name order by id
试试就知道了 :)

[okiamsorry]

那不是很简单，select min(id),name from 表A group by name into #temp_A
truncate table 表A
insert into 表A select * from #temp_A
drop #temp_A

[godidea]

to okiamsorry(hsblank)

有没有好一点的方法

这样表大的时候不是很惨

[FeelingL]

friendliu(无为)等的方法不正确

[nancyzhou]

select distinct * into #Temp
from 表A
drop table 表A
select * into 表A from #Temp
drop table #Temp

或 delete a from 表A a join 表A b on a.Name=b.Name and a.Id>b.Id