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

how we can fire event in databound column in datagrid without using button?

1023

Define the mesi? : Dot net architecture

934

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

1028

Can you explain control extenders?

963

What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile

943

data types used in validation control

2205

Can you explain update progress control?

930

What is an asssembly qualified name? Is it a filename? How is it different?

940

Explain Intermediate Language?

1063

how to create applications by using Visual Studio 2012?

958

Explain cache memory? : .NET Architecture

981

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

2336

What is the purpose of cache? : Dot net architecture

989

How do I write to the application configuration file at runtime?

996

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

1032