Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Delete duplicate reords ( one of them)

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts

Posted - 2004-10-01 : 10:18:42

I have a table called test:

name id
a 10024
a 10024
b 10025
c 10026
d 10027
e 10028
e 10028

I would like to delete the duplicate record ( one of them). The output should look like:
name id
a 10024
b 10025
c 10026
d 10027
e 10028




ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-10-01 : 10:30:32
Have a look at the following article:

http://www.sqlteam.com/item.asp?ItemID=3331
Go to Top of Page
   

- Advertisement -