delete from emp where rowid not in(select max(rowid) from emp group by sal

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

Question Posted / srinivas

Answer Posted / srinivas

delete from emp where rowid not in(select max(rowid) from
emp group by sal);
and
delete from(select distinct sal from emp) where rowid>=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain oracle apps architecture.

1301

Tell me how to debug the report?

1172

can we use look up type instead of a pofile option?or valueset?is it possible how?

2264

testing tools?

2301

what is the difference between request group and request security in oracle apps?

5976

What do you understand by a set of books?

1153

Explain what are the tables of auto invoice?

1196

tell me the scenarios of the independent in reports

2658

What is a value set? List its various types.

1142

tell my any difficult situtation you solved in your experience in your company?

2363

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

2708

What does appl_top directory contain?

1167

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3732

Tell me where we find the status of order information?

1194

What is instead of trigger in where we will use?

1220