How to delete the duplicate records in a table using sql
server
- 4 Answers
- 4692 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rakesh pattajoshi
delete from tbl where id not in(select max(id) from tbl group by name)
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Video Streaming in .net??
what are the things we generally declare in session_start , application_start ?
What is the difference between custom controls and master page?
What is textview control of .net mobile? : Microsoft dot net mobile
Session State and can i store desirialized object in state server, if yes how and if not why.
i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?
what are constructors and destructors?
Explain the Lapsed Listener problem in .net
How to prevent my .NET DLL to be decompiled?
What is cookie less session?
Tell me .net mobile emulators? : Microsoft dot net mobile
What is an asssembly qualified name? Is it a filename? How is it different?
Dot Net Framework 
