Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14739 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 pl sql and why it is used for?
Does view store data in sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is nvarchar max in sql?
Is primary key is clustered index?
What is plpgsql language?
What do you understand by exception handling in pl/sql?
How does pl sql work?
Difference between global and parameter variables?
Is sql low level language?
What is the difference between drop and truncate commands?
Can a table have no primary key?
What is t sql used for?
How do I turn a list into a table?
What is rowid in sql?
