I don;t think the above will work

plese try the following

Delete from emp a where a.rowid > ( select min(rowid) from emp b

where a.empno b.empno group by empno)

Matloob Hussain

Hello

What you mean eliminate does it mean to delete the rows or to de-select the duplicate rows..

We can use either distinct or rowid to eliminate duplicate rows

delete from <table name> a1 where a1.rowid > any (select rowid from <table name> a2 where a1.<col name> a2.<col name>;

This works....

Regards

Satish Kumar

there are around 4 ways to eliminate duplicate records upto my knowledge.

the first preferable answer u have to say is :

delete from table_name where rowid not in (select min(rowid) from table_name group by column_name)

if the interviewer asks for another method: try this method.

1. create table_name_b as select distinct * from table_name_a;

2. drop table_name_a;

3. rename table_name_b as table_name_a;

Finished...

and the remaingin methods r confusing where as u will be stopped as soon as u say these 2 types ..

Thanx..