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


Please Help Members By Posting Answers For Below Questions

Explain write back and write through caches? : Dot net architecture

546


Explain about .net garbage collector?

554


8. Oop-Why and were we use Interfacse and Abstract class.

1585


What is code access security (cas)?

565


How can we integrate atlas with web services?

519






What is cache coherency and how is it eliminated? : .NET Architecture

526


Name some changes done since version 3.0?

551


Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?

605


Explain different pipelining hazards and how are they eliminated? : .NET Architecture

503


What is a virtual memory? : .NET Architecture

530


What are the five stages in a dlx pipeline? : Dot net architecture

511


Explain about generation?

568


Explain about cookie less session state? : .NET Architecture

553


Define domestic architecture artifacts? : Dot net architecture

521


What is the mesi? : Dot net architecture

542