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
Explain the difference between primary & secondary storage device? : Dot net architecture
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
6. Wcf- what is SOA
What are relation objects in dataset?
Explain Intermediate Language?
What is cache coherency? : Dot net architecture
What is different about namespace declaration when comparing that to package declaration in java?
What is .net mobile images control. Explain with an example? : Microsoft dot net mobile
How do I stop a thread?
Differnce between managed code and unmanaged code ?
Explain the difference between l1 and l2 cache? : .NET Architecture
Can you explain control extenders?
Whats new features in Visual Studio 2012?
What are the five stages in a dlx pipeline? : Dot net architecture
define cache memory? : Dot net architecture