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
Explain write back and write through caches? : Dot net architecture
Explain about .net garbage collector?
8. Oop-Why and were we use Interfacse and Abstract class.
What is code access security (cas)?
How can we integrate atlas with web services?
What is cache coherency and how is it eliminated? : .NET Architecture
Name some changes done since version 3.0?
Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?
Explain different pipelining hazards and how are they eliminated? : .NET Architecture
What is a virtual memory? : .NET Architecture
What are the five stages in a dlx pipeline? : Dot net architecture
Explain about generation?
Explain about cookie less session state? : .NET Architecture
Define domestic architecture artifacts? : Dot net architecture
What is the mesi? : Dot net architecture