Message-Id: <10622.117222@fatcity.com> From: Abdul Aleem Date: Mon, 18 Sep 2000 10:08:00 +0500 Subject: RE: Deleting Duplicate Rows Dear Khan, You need to create a cursor with the primary key of the table plus a column SUM(1) AS cntr, group by the primary key and add HAVING Cntr > 1. Now use DELETE WHERE [Primary key] IN SELECT( PK from the cursor) HTH! Aleem -----Original Message----- From: Azizulah Khan [mailto:Azizulah.Khan@almarai.com] Sent: Sunday, September 17, 2000 9:58 PM To: Multiple recipients of list ORACLE-L Subject: Deleting Duplicate Rows Dear Khan, You need to create a cursor with the primary key of the table plus a column SUM(1) AS cntr, group by the primary key and add HAVING Cntr > 1. Now use DELETE WHERE [Primary key] IN SELECT( PK from the cursor) HTH! Aleem Hi list, Do anyone have idea of deleting duplicate rows without using ROWID from the table ????. TIA Khan -- Author: Azizulah Khan INET: Azizulah.Khan@almarai.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).