delete from emp e1 where rowid >(select min(rowid) from emp e2 where e

how to delete all duplicate records from a table using
subquery?

Question Posted / dharmendra

Answer Posted / dharmendra

delete from emp e1 where rowid >(select min(rowid) from emp
e2 where e1.empid=e2.empid)

Is This Answer Correct ?

12 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what is the scenario where you take the database to NoArchivelog mode?

2330

What is the oracle implicit cursor?

1062

how do u setup a replication site?

1983

what are archived logs?

2199

What is the use of file param in imp command?

1165

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1882

Can we create database in oracle using command line ?

1085

How to define an anonymous block?

1156

How to test null values?

1105

What is a relational database management system?

1120

What is transport network substrate (tns) in oracle?

1046

Explain the use of record length option in exp command.

1067

How to define a record variable to store a table row?

1058

What is the data pump export utility?

1081

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4585