Delete duplicate records in the emp table.
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 sqlcommand?
Why functions are used in sql?
Does mysql support pl sql?
What is difference between primary and secondary key?
what are rollup and cube in t-sql? : Transact sql
How to display the records between two range in Oracle SQL Plus?
What is column?
How do you drop a trigger?
What is trigger in sql?
What are all the different normalization?
What is the primary use of normalization?
Can delete statement be rollbacked?
What is difference between sql and oracle?
Why stored procedure is faster than query?
how can we repair a mysql table? : Sql dba