How to delete the duplicate records in a table using sql
server
- 4 Answers
- 4402 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 |
how to use custom field validation
How cache is used? : Dot net architecture
What is .net mobile forms? : Microsoft dot net mobile
what are ACID properties ?
When do I need to use gc.keepalive?
what are constructors and destructors
What does the term "green architecture" mean? : .NET Architecture
What are the major differences between services and web services?
Explain the race around condition? How can it be overcome? : Dot net architecture
What is MS chart control in visual studio?
how can u manage sessions ?
i want to know that now a days which software course has demand and more opportunities please give me reply to my mail id
Dot Net Framework 
