RE: how to identify table dublicates just using rowid ?

[Ahmed Gholam Hussain]

Hi Salah ,   This is a sample query on how to identify the duplicate rows : Select FROM tablename WHERE rowid not in (SELECT MIN(rowid) FROM tablename GROUP BY column1, column2, column3...);   Hope it helps….     ---------------------------------------------------------------------------         -----Original Message----- From: Salaheldin Aboali [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Subject: how to identify table dublicates just using rowid ?   hi all, how to identify or list table dublicates just using rowid ? Regards, Salaheldin Aboali ------------------------------------------- Senior Software Developer Management Information Systems http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65