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

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

Question Posted / xyz

Answer Posted / xyz

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

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?

2230

what are the balancing segments in AR?

2103

What is a value set? List its various types.

1103

What are the Standard Reports and Forms in HRMS?

2321

how can i print random rows in plsql table

2507

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

2112

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

2267

List the various types of value set.

1085

tell me the scenarios of the independent in reports

2627

How can you achieve loose coupling in soa framework?

1233

Can we create tables in apps schema?

1148

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

2083

In oracle application how do you debug or trace errors?

1125

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

2069

what is pay run id ?

2203