Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 76969 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / ajith
DELETE FROM EMP E1
WHERE E1.ROWID>(SELECT MIN(E2.ROWID)
FROM EMP E2
WHERE E1.EMPNO=E2.EMPNO)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In hierarchical structure of a database? we have write query from where we should start?
Tell me how to debug the report?
how do you describe O2C along with tables
q)what are the validations in sql*loader
what is pay run id ?
How can a process be deployed in soa?
In sequence i want to 11 and 15th values how we will write?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What do you understand by concurrent programs?
what is the differences between internal requisition and internal sales order?
Tell me where we find the status of order information?
How many schemas we have? how many you have used?
how to print multi lay outs,muti currency,muti language in xml publisher
Can you differentiate between mediator and osb?
What is oracle soa suite and what are its different components?
