Delete from <TableName> where <fieldName> in (select <Fiel

How To delete duplicate record from a particular table?

Question Posted / parashu

Answer Posted / parashu

Delete from <TableName> where <fieldName> in (select
<FieldName> from <TableName> Group By <FieldName> Having
(Count(<FieldName>)>1))

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

List the types of recovery model available in sql server?

921

Do you know the cursor types?

1150

What is sql profiler. What are the default templates with it? : sql server database administration

1026

What is catalog views?

1062

explain how to create a new schema in a database? : Sql server database administration

1104

Explain the disadvantages/limitation of the cursor?

951

Define cursor locking

995

What type of locking occurs during the snapshot generation? : sql server replication

1328

How many partitions a clustered index has by default in sql server 2012?

1083

how many no of arguments can be passed in procedures and functions

5545

Define self join in sql server joins?

947

How to create an multi-statement table-valued function?

983

What are the different editions available in sql server 2000?

1042

What is resultset concur_updatable?

1013

Explain datetime2 data type in sal server 2008?

898