Deleting Duplicate records - SQL Server Forums

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)

Deleting Duplicate records

Author

Topic

shahul
Starting Member

1 Post

Posted - 2002-06-26 : 10:28:22

How can delete duplicate records in SQL Server without affecting the original.

Assume there is no constraints.

For ex

Empid Name
------------
1001 Anees
1001 Anees

I want to delete the second one only.

Shahul

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-06-26 : 10:34:06

I think Graz has answered this before

http://www.sqlteam.com/item.asp?ItemID=3331

-----------------------
Take my advice, I dare ya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources