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
12134 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

What is row_number function?

947

What is raid? : SQL Server Architecture

1111

How many types of database relationship in sql server?

1005

How do you create an execution plan?

893

What is the purpose of floor function?

980

How to optimize stored procedure optimization?

849

how you can move data or databases between servers and databases in sql server? : Sql server administration

921

How to use "begin ... End" statement structures in ms sql server?

965

What is cursor in ms sql server?

1094

Explain four layers of abstraction microsoft architectured?

147

What are subqueries in sql server?

1068

What do you understand by mirroring?

957

What are sql dirty pages?

979

How to generate create procedure script on an existing stored procedure?

945

Tell me what are the essential components of sql server service broker?

891