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

Why am I getting an invalidoperationexception when I serialize an arraylist?

835

Can you explain atlasuiglitz library?

886

Explain about metadata?

882

How can I write my own .NET host?

959

hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays

2295

deference between display and visibility property of CSS

2216

What is the difference between .net mobile pages and ordinary .net web page? : Microsoft dot net mobile

887

Explain Intermediate Language?

1025

Can I create my own metadata attributes?

978

What is Opf3

956

Explain the process of gc?

937

Explain the race around condition? : .NET Architecture

941

How to upload in video,mp4,in .net 4.5 ..?

893

where should I put this information then?

921

what is diffrent beatween localprinter and networkprinter

1699