How to delete the duplicate records in a table using sql
server
- 4 Answers
- 4807 Views
- I also Faced
- E-Mail Answers
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
Define a managed code? : Dot net architecture
What does this do? Gacutil /l | find /i "corillian"
how to delete the record using data reader
how to make and display a form without title bar?
What are the options provived by vss to the user? how it will help us while delevoping application?
Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
What is the mesi? : Dot net architecture
The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.
Difference between throw exception and rethrowing ?
Explain difference between machine config vs. Web config? : .NET Architecture
State the different levels of exceptional safety?
inprocess vs out process session state : Dot net architecture
Define cache coherency and how is it eliminated? : Dot net architecture
What actually happes when you add a something to arraylistcollection ?
