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

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

1777

List the types of flexfield?

596

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

673

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

1512

In sequence i want to 11 and 15th values how we will write?

1567

How can you achieve loose coupling in soa framework?

712

Plz anybody send me Technical specification for AP Interface

1999

Explain what are the tables of auto invoice?

638

What do you understand by concurrent programs?

613

how do you describe O2C along with tables

2307

What is oracle soa suite?

755

What is the concept of soa governance?

760

What is a value set? List its various types.

644

What are file in oracle.

1801

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

642