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

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

2132

tell me the scenarios of the independent in reports

2054

what are the balancing segments in AR?

1655

Can you explain the difference between architecture followed in 10g & 11g?

667

Can you differentiate between mediator and osb?

627

How is choreography different from orchestration?

656

What does appl_top directory contain?

652

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

2227

Plz anybody send me Technical specification for AP Interface

2019

q)what are the validations in sql*loader

1746

What are file in oracle.

1816

What is oracle soa suite and what are its different components?

650

What is the concept of soa governance?

776

What is count(*) from po_vendors(any table)?

645

In hierarchical structure of a database? we have write query from where we should start?

1710