Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 15016 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
How do I debug a stored procedure?
How can I delete duplicate rows?
Why use stored procedures?
what is a database lock ? : Sql dba
What is self-join and what is the requirement of self-join?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How sql query is executed?
Can we rollback truncate?
what is bcp? When does it used? : Sql dba
Can you have more than one key in a database?
Can a table contain multiple foreign key’s?
What does the sign mean in sql?
When sql appeared?
Is join and inner join the same?
What does the hierarchical profiler does?
