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

What are the benefits of using soa architecture?

1252

Explain oracle apps architecture.

1252

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2387

how to print multi lay outs,muti currency,muti language in xml publisher

12289

What are file in oracle.

2238

In oracle application how do you debug or trace errors?

1115

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

1219

What are do's and dont's of Interface?

2430

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3065

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

2663

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

2266

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2131

Tell me how to find the custom directory in front end?

1111

Can we create tables in apps schema?

1143

Can u give the Documentation of Custom.pll in oracle apps

3478