Answer Posted / madhav

DELETE FROM emp1 A WHERE ROWID > (SELECT min(rowid)
FROM emp1 B
WHERE A.empno = B.empno);

---conn scott/tiger@orcl
create table emp1 as select*from emp;
14 rows inserted
SQL> select*from emp1;

14 rows selected
-----------
insert into emp1
selectempno,ename,job,mgr,hiredate,sal,comm,deptno from emp;

14 row inserted

select*from emp1;

28 rows slected --(14 duplicates row are there)

you can use starting query duplicates rows deleted

Email:thota.madhav@gmail.com

how can we repair a mysql table? : Sql dba

988

---

How many triggers can be applied to a table?

1069

---

What do you mean by query optimization?

1007

---

How to create an array in pl/sql?

1074

---

what is bcp? When is it used?

1119

---

Can you selectively load only those records that you need? : aql loader

1049

---

what are null values? : Sql dba

960

---

What is optimistic concurrency control? : Transact sql

989

---

Differentiate between syntax and runtime errors.

1195

---

What is pl sql in oracle?

1047

---

What is the difference between union and union all command?

1096

---

What is the difference between a subquery and a join?

1114

---

Is sql sequential or random?

1041

---

What is foreign key and example?

942

---

Explain constraints in sql?

1052

---