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 are bindings?

558

Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

500

I can't be bothered with cas. Can I turn it off?

532

What are the major differences between services and web services?

495

What is .net mobile lists. : Microsoft dot net mobile

478

What is cache coherency? : Dot net architecture

491

What are the important principles of soa (service oriented architecture)?

497

Explain Singleton design pattern in .net

576

What is the difference between an application and a program?

492

what are constructors and destructors?

1722

what are login controls?

1409

Explain difference between inprocess vs out process session state? : .NET Architecture

540

server.transfer limitation ?

1794

Define domestic architecture artifacts? : Dot net architecture

527

Explain dotnet framework ?

525