Delete duplicate records in the emp table.
Answer Posted / 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 |
Post New Answer View All Answers
What is cross join example?
What does count (*) mean?
What is on delete set null?
What is bitemporal narrowing?
What is the difference between sum and count in sql?
What are the types pl/sql code blocks?
How many parts of a pl sql block are optional?
What is an oracle stored procedure?
What is difference between ms sql and mysql?
what is log shipping? : Sql dba
Explain scalar functions in sql?
What is difference between joins and union?
How exception is different from error?
What is sqlservr exe?
How to place comments in pl/sql?