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 does the term "green architecture" mean? : Dot net architecture

947

Explain the race around condition? How can it be overcome? : Dot net architecture

1012

Explain COM with example?

1010

What is gui programming? : .NET Architecture

970

What is the purpose of Treeview control?

1051

How do I prevent concurrent access to my data?

1079

question related to table havi colspan and row span

2312

Explain the process of gc?

1030

What is the access level of the visibility type internal?

1005

Explain element .net mobile with example? : Microsoft dot net mobile

1012

Explain about validation?

1046

Explain Singleton design pattern in .net

1045

Explain pipelining? : .NET Architecture

1011

Explain cache memory? : Dot net architecture

1011

What is the use of web.config?

1176