Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14561 Views
- Oracle, I also Faced
- E-Mail Answers
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
Explain correlated query work?
What does dml mean?
How can you view the errors encountered in a trigger?
What does the sign mean in sql?
How do I view tables in sql developer?
How to write pl sql program in mysql command prompt?
Why do we use sqlite?
What is mdf ldf and ndf?
What is raw datatype in sql?
Can you selectively load only those records that you need? : aql loader
How to read xml file in oracle pl sql?
How do I send sql query results to excel?
Why do we use joins in sql?
Explain the difference between drop and truncate commands in sql?
Which are the different character-manipulation functions in sql?
