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 I see all tables in sql?

542

---

Is sql free?

499

---

Are sql database names case sensitive?

496

---

How to combine two stored procedures in sql?

591

---

What is meant by user defined function?

581

---

---

What is the difference between a database and a relational database?

558

---

How to run sql commands in sql*plus?

583

---

what is data manipulation language? : Sql dba

527

---

What are the benefits of triggers?

596

---

Is left join and outer join same?

544

---

Cite the differences between execution of triggers and stored procedures?

617

---

Why we use joins in sql?

536

---

What is t sql used for?

549

---

Is inner join faster than left join?

629

---

How do you update a table in sql?

519

---