Check following blog post on how to first identify & then delete duplic

Delete duplicate records from the table?(Table must have
unique id)

Question Posted / manoj

7 Answers
12321 Views
TCS, Thomson Reuters, I also Faced
E-Mail Answers

Answer Posted / manoj

Check following blog post on how to first identify & then delete duplicate records: http://sqlwithmanoj.wordpress.com/2011/10/14/identify-delete-duplicate-records-from-a-table/

This lists multiple ways to delete duplicates.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sql server 2016 have ssms?

952

How to round a numeric value to a specific precision?

1066

How to add additional conditions in SQL?

1018

How do I find the sql server database version?

998

How would we use distinct statement? What is its use?

1066

Describe how to use linked server?

1007

what's the information that can be stored inside a bit column? : Sql server database administration

1019

How to retrieve error messages using mssql_get_last_message()?

1040

What is Replication?

1039

What is change data capture (cdc) in sql server 2008?

1019

How many database files are there in sql server 2000?what are they?

1048

Differentiate between a having clause and a where clause.

960

What are the advantages of sql stored procedure?

1061

What is function of master database?

114

What are the advantages of paper records?

959