eliminating Duplicate Rows from a table

[Stevenson]

Hi,

I'd like to know the query which uses Rowid stuff to elimante duplicate rows
from a table

thanx
Steve

 

[kindus]

Here is a piece of code which gives rowids,empno of emp1 table

select rowid,empno from emp1
where empno in (
select empno from emp1
group by empno
having count(*) > 1
)
/

Hence you can delete any duplicates/triplicates etc. based on the rowid. It is to delete employees having duplicate empno.

Hope it will help you.

 

[chidi]

You can also try this:

delete from table_name t1
where t1.column_name in (select column_name
from table_name t2
where t1.rowid > t2.rowid
and t1.column_name = t2.column_name
Chidi

 

[Stevenson]

Thanx Very much guys
Steve