How to delete the duplicate records in a table using sql
server
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
What's the difference between an application and a program?
Explain COM with example?
Explain .net mobile events? : Microsoft dot net mobile
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.
What is a service class?
Differnce between managed code and unmanaged code ?
Define dma? : Dot net architecture
Explain a .net mobile example with details? : Microsoft dot net mobile
What are the options provived by vss to the user? how it will help us while delevoping application?
Explain dma? : .NET Architecture
Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile
What is an asssembly qualified name? Is it a filename? How is it different?
What are the different pipelining hazards? : Dot net architecture
Explain different pipelining hazards and how are they eliminated? : .NET Architecture
What are the main Tools to develop .Net Application?