Delete duplicate records in the emp table.

Answers were Sorted based on User's Feedback



Delete duplicate records in the emp table...

Answer / 14-07-2007

delete from emp where rowid not in(select min(rowid) from
emp group by empno;

Is This Answer Correct ?    13 Yes 2 No

Delete duplicate records in the emp table...

Answer / smriti

delete from tablename a where a.rowid>(select min(rowid)
from tablename b where a.columnname=b.columnname)

Is This Answer Correct ?    8 Yes 1 No

Delete duplicate records in the emp table...

Answer / srinivas ganamur

Delete from table t1
where t1.rowid>(select from table t2
from table t2
where t1.col_name=t2.col_name);

Srinivas Ganamur
Bangalore

Is This Answer Correct ?    7 Yes 3 No

Delete duplicate records in the emp table...

Answer / ch. nageswar subudhi

For delete the DUPLICATE RECORD from Table by using this
Query:

DELETE FROM EMP E
WHERE E.ROWID <>(SELECT MIN(ROWID) FROM EMP E2 WHERE
E.EMP_NO=E2.EMPNO);

Is This Answer Correct ?    4 Yes 3 No

Delete duplicate records in the emp table...

Answer / amedela chandra sekhar

delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);

Is This Answer Correct ?    0 Yes 0 No

Delete duplicate records in the emp table...

Answer / valli

delete from emp where rowid in(
select rowid from (
select emp_no, sal,rownum() over (emp_no,sal) as
Rownum from emp order_by emp_no,sal
) where rownum > 2
)

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What is foreign key in sql with example?

0 Answers  


How does index help in query performance?

0 Answers  


display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,


What is count * in sql?

0 Answers  


What is difference between db2 and sql?

0 Answers  






What is scalar and vector?

0 Answers  


What is difference between hql and sql?

0 Answers  


Explain what is a column in a table?

0 Answers  


Can procedure in package be overloaded?

0 Answers   EXL,


what is a foreign key ? : Sql dba

0 Answers  


where are cookies actually stored on the hard disk? : Sql dba

0 Answers  


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  


Categories