sql ɾ³ýÖظ´µÄ¼Ç¼

SQL code:
±íA
id name
1 aa
2 aa*
3 aa**
4 bb
5 bb*
6 cc
7 dd
8 dd**
9 ee

ÒÔÉÏnameÖдø*µÄÊý¾Ý¿Ï¶¨¾ÍÊÇÖظ´µÄÊý¾Ý
ÎÒÏëɾ³ýËùÓеÄÖظ´ÐÅÏ¢
¸ù¾Ý±íAµÃµ½µÄ½á¹ûΪ

id name
1 aa
4 bb
6 cc
7 dd
9 ee

ÄÄλ֪µÀÔõôʵÏֵİïÎÒ½â¾öÏÂ

---

SQL code:
select * from tb t where id=(select min(id) from tb where name=t.name)

---

http://topic.csdn.net/u/20080626/00/43d0d10c-28f1-418d-a05b-663880da278a.html?73339

---

¾«華Ìû~~

---

SQL code:
delete tb
where exists(select 1 from tb t where t.name=tb.name and t.id<tb.id)

---

SQL code:


--> ²âÊÔʱ¼ä£º2009-12-09 11:03:53
--> ²âÊÔ²ËÄñ£ºl8r
--> ÎÒµÄÌÔ±¦£º[url=http://shop36766744.taobao.com/]¡¶½äÉ«·»¡·http://shop36766744.taobao.com/[/url]

[code=SQL]

if object_id('[±íA]') is not null drop table [±íA]
create table [±íA]([id] int,[name] varchar(2))
insert [±íA]
select 1,'aa' union a