Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14578 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
what is top in tsql? : Transact sql
How to run sql commands in sql*plus?
Can we connect to postgresql using sql developer?
How many subqueries can be nested in a statement?
What is procedure explain with program?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the difference between database trigger and stored procedure?
What is primary key secondary key alternate key candidate key?
Explain the working of foreign key?
What is equi join in sql?
What is constant in pl sql?
Are subqueries faster than joins?
What does pragma mean?
What type of database is sql?
List different type of expressions with the example.
