delete from employ where rowid not in(select min(rowid) from employ group

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

Question Posted / arjun

Answer Posted / arjun

delete from employ where rowid not in(select min(rowid) from
employ group by id,ename,age);

Arjun

Is This Answer Correct ?

17 Yes

7 No

Please Help Members By Posting Answers For Below Questions

List the types of flexfield?

1045

what are the different transaction clauses in AR?

2121

What do you understand by soa?

1163

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

Which oracle apps version you are very confident in?

1216

How can a process be deployed in soa?

1276

How do you register report in oracle apps?

1100

How can we import the data into a database using sql * loader?

1196

What are the different components of soa suite?

1214

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

1986

In support project one ticket alloted which steps follows manualy tell me ?

2668

how do you describe O2C along with tables

2776

Do you know where we can check the status of po?

1293

How is choreography different from orchestration?

1140

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2266