For delete the DUPLICATE RECORD from Table by using this Query: DELETE

Delete duplicate records in the emp table.

Question Posted / ch. nageswar subudhi

6 Answers
15025 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

Please Help Members By Posting Answers For Below Questions

What is sql query optimization?

1194

Can you rollback after commit?

1053

What is a table partition?

1208

What is break?

1256

What is the use of pl/sql table?

1105

What is the need of a partition key?

1030

What is identity column in sql server?

1102

What is flag in sql?

1099

what is timestamp in mysql? : Sql dba

1133

What is the difference between having clause and where clause?

1116

Does sql view stored data?

1003

What is the largest value that can be stored in a byte data field?

1060

what is the use of friend function? : Sql dba

1062

What are pl/sql cursors?

1103

how to convert dates to character strings? : Sql dba

1253