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

who introduced sql?

1072

---

Is primary key is clustered index?

1041

---

How can I see all tables in sql?

1141

---

What is full join?

1019

---

Explain select statements in sql?

1105

---

How do I remove sql developer from windows 10?

1181

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1032

---

Where not exists in sql?

1032

---

What is posting?

1083

---

When can we use the where clause and the having clause?

1082

---

how many tables will create when we create table, what are they? : Sql dba

1114

---

What is identity column in sql server?

1102

---

How do you create a db file?

1067

---

Can you rollback after commit?

1049

---

what is a primary key? : Sql dba

1086

---