How to delete the duplicate records in a table using sql
server
- 4 Answers
- 4403 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
State the different levels of exceptional safety?
What is Video Streaming in .net??
What is .net mobile input validation. : Microsoft dot net mobile
Explain the process of gc?
how to change the application name?
Explain the use of virtual, sealed, override, and abstract.
question related to table havi colspan and row span
How do I stop a thread?
What is the application frame host?
Does application frame need host?
Can you explain scriptmanager control?
Why am I getting an invalidoperationexception when I serialize an arraylist?
Explain the purpose of cache? How is it used? : .NET Architecture
Difference between type constructor and instance constructor?
can u give me real example of how web.config overrides the machine.config file?
