Delete duplicate records in the emp table.

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / lakshmimca85@yahoo.com

6 Answers
14621 Views
Oracle, I also Faced
E-Mail Answers

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