delete from emp where rowid not in ( select max(rowid) from emp group by em

How to delete the duplicate records from table(having bulk
records)?

Question Posted / rajani

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

Please Help Members By Posting Answers For Below Questions

What is the problem with .net generics?

1074

Explain the race around condition? : Dot net architecture

906

How can I create a application?

934

What is biginteger and when would you use that?

944

Explain about microsoft visual studio?

974

Difference between throw exception and rethrowing ?

2120

What is the .net class that allows the retrieval of a data element using a unique key?

1017

Explain the difference between l1 and l2 cache? : .NET Architecture

1038

How cache coherency is eliminated? : Dot net architecture

922

What re interop services?

1008

What is different about namespace declaration when comparing that to package declaration in java?

1040

What are the new features of .net 2.0?

966

What is a service class?

1009

how to add list of items in a web application and win application?

2072

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

980