How to delete the duplicate records from table(having bulk
records)?
Answer Posted / rajani
delete from emp where rowid not in ( select max(rowid) from emp group by empno )
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture
Does .NET runtime offer Deterministic Destruction or not?
Explain some of the disadvantages due to microsoft.net?
How do we do authentications using atlas?
What is the purpose of cache? : Dot net architecture
What does the term "green architecture" mean? : .NET Architecture
What are the important principles of soa (service oriented architecture)?
Explain difference between machine config vs. Web config? : .NET Architecture
how to add list of items in a web application and win application?
How cache coherency is eliminated? : Dot net architecture
Is .net easier than java?
Define pipelining? : 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.
how to use custom field validation
what are constructors and destructors?