Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14795 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 to get unique records from a table?
What is a sql profiler?
How do you select unique values in sql?
Why trigger is used in sql?
What are the disadvantages of not performing database normalization?
How do I edit a stored procedure?
What is the order of sql select?
What are the operators in sql?
What are different types of tables in sql?
How does join work in sql?
what is data control language? : Sql dba
How do I start sql from command line?
what are enums used for in mysql? : Sql dba
What is pl sql quora?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
