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
12568 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 do you mean by acid?

1058

What are the different sql server versions?

1034

Explain the difference between clustered and non-clustered index?

971

What is data source object?

1067

How can we use ConnectorJ JDBC Driver with MS SQL?

1053

What are triggers? How do you invoke a trigger on demand?

1367

What are database states in ms sql server?

1247

What is log in sql server?

1205

What is dimension table? : sql server analysis services, ssas

1066

Write a sql query to delete duplicate records from a table called table1

1088

Explain how dts is used to extract, transform and consolidate data?

1050

What are the kinds of subquery?

1074

What is a collation?

1134

How do you run a trace?

947

how can you attach more than 20 ldf files in sql server

2052