DELETE FROM EMP E1 WHERE E1.ROWID>(SELECT MIN(E2.ROWID)

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / ajith

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

Please Help Members By Posting Answers For Below Questions

How many schemas we have? how many you have used?

2112

How to create a purchase order without a requisition?

1253

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2157

What do you understand by concurrent programs?

1145

What is a value set? List its various types.

1142

what is the differences between internal requisition and internal sales order?

2708

testing tools?

2301

q)what are the validations in sql*loader

2456

is it possible to run the interface without using oracle apps?

2024

what is global tempory table?

7293

Explain what are the tables of auto invoice?

1196

What are the benefits of using soa architecture?

1323

Tell me where we find the status of order information?

1194

What do you understand by soa and what are the benefits of using this architecture?

1143

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2671