Hi
Table A got some duplicated rows.. The requirement is to delete the
duplicate records by maintaing one copy..
Is it manageable thru single query? or have to go for PL/SQL procedure?
Pl. send me ur valuable inputs.
Saravanakumar
--
Please see the official ORACLE-L FAQ:
I think this query eliminates the duplicated rows:
delete from table_name where rowid not in (select maxrowid from (select
column1,column2, max(rowid) maxrowid from den group by column1,column2));
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
I am sorry I made a mistake in naming . Correct one is below:
delete from table_name where rowid not in (select maxrowid from (select
column1,column2, max(rowid) maxrowid from table_name group by
column1,column2));
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Yes, It works .. Thanks..
On Fri, 25 May 2001, [iso-8859-1] Burçin Üstün Kýlýç wrote:
I think this query eliminates the duplicated rows:
delete from table_name where rowid not in (select maxrowid from (select
column1,column2, max(rowid) maxrowid from den group by column1,column2));