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

Explain scalar functions in sql?

1017

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

918

---

Can we group by two columns in sql?

944

---

What is embedded sql with example?

985

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

893

---

Is left join faster than inner join?

1063

---

Can we use ddl statements in stored procedure sql server?

965

---

what is schema? : Sql dba

986

---

What is a temporal data type?

979

---

What is the purpose of primary key?

966

---

What are the ways on commenting in a pl/sql code?

1051

---

What is the maximum size of sqlite database?

1040

---

Why do we use procedures in pl sql?

962

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

898

---

What are pl/sql cursor exceptions?

1036

---