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

What is data compression? : sql server database administration

976

Explain hostprotectionattribute in sql server 2005?

1035

How do you size a resultset?

914

How to drop an existing stored procedure in ms sql server?

1032

What is bcnf normalization form?

1115

Can you edit the .rdl code associated with a linked report?

163

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1210

How do I find my localdb version?

987

What can be used instead of trigger?

1156

whats new about truncate in sql server 2008?

2502

What guidelines should be followed to help minimize deadlocks?

944

Can I disable or restrict ssrs export formats (rendering formats)?

150

Can we use max in where clause?

925

What is sql sandbox in sql server?

1226

Where can you find the error log information? : sql server database administration

1026