Delete duplicate records in the emp table.
- 6 Answers
- 12994 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 does postgresql compare to mysql?
Why stored procedures are faster than query?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
Explain ttitle and btitle.
Explain two easy sql optimizations.
How do you update a table in sql?
What is sql deadlock?
How do you rank data in sql?
What are database links used for?
What is sql prepared statement?
Does mysql_real_escape_string prevent sql injection?
Describe different types of general function used in sql?
What is a native sql query?
How do you delete a table?
Can we commit in trigger?
