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
 General SQL Server Forums
 New to SQL Server Programming
 please help

Author  Topic 

Laith Scofield
Starting Member

10 Posts

Posted - 2010-08-09 : 18:30:21
hi guys
can u tell me how delete duplicate records in the same table by using sql ?

"It's fine to celebrate success but it is more important to heed the lessons of failure."
Bill Gates

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-09 : 21:47:53
What version of SQL Server are you running?

Also, please give a few sample records and we'll help you out
Go to Top of Page

Laith Scofield
Starting Member

10 Posts

Posted - 2010-08-10 : 00:39:48
2008 r2

"It's fine to celebrate success but it is more important to heed the lessons of failure."
Bill Gates
Go to Top of Page

kashyap_sql
Posting Yak Master

174 Posts

Posted - 2010-08-10 : 01:07:27
http://blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/
just go through the link

With Regards
Kashyap M
Go to Top of Page
   

- Advertisement -