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

What is the most common sql injection tool?

1037

---

What is sp_helptext?

1057

---

What is rownum?

972

---

Which is better varchar or nvarchar?

990

---

What are the benefits of stored procedures?

1057

---

What is the starting oracle error number? What is meant by forward declaration in functions?

984

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

1064

---

Can we insert in sql function?

1078

---

What is sql used for?

1113

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

991

---

Explain 3 basic parts of a trigger.

1304

---

What is the non-clustered index in sql?

1056

---

What is a unique constraint?

1065

---

What are sql constraints?

1172

---

what is top in tsql? : Transact sql

1113

---