Delete duplicate records in the emp table.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
What is foreign key in sql with example?
How does index help in query performance?
display records from 5 to 9 using rowid or rownum
What is count * in sql?
What is difference between db2 and sql?
What is scalar and vector?
What is difference between hql and sql?
Explain what is a column in a table?
Can procedure in package be overloaded?
what is a foreign key ? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?