How to delete the duplicate records in a table using sql
server

Answer Posted / mohamed idhris

SET ROWCOUNT 1

DELETE FROM tbl_name WHERE field_name= 'field_value'

SET ROWCOUNT 0


the above query will delete the duplicate row

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between primary & secondary storage device? : Dot net architecture

717


How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts

842


6. Wcf- what is SOA

2054


What are relation objects in dataset?

743


Explain Intermediate Language?

852


What is cache coherency? : Dot net architecture

693


What is different about namespace declaration when comparing that to package declaration in java?

742


What is .net mobile images control. Explain with an example? : Microsoft dot net mobile

717


How do I stop a thread?

730


Differnce between managed code and unmanaged code ?

743


Explain the difference between l1 and l2 cache? : .NET Architecture

769


Can you explain control extenders?

709


Whats new features in Visual Studio 2012?

739


What are the five stages in a dlx pipeline? : Dot net architecture

739


define cache memory? : Dot net architecture

738