Re: Duplicate records

Hi Sushma,

Try using this sql :

delete from <table>
where rowid in
(select a.rowid
 from <table> a, <table> b
 where a.primary_key = b.primary_key
 and a.rowid < b.rowid
)

This assumes that the table has a primary key.

Good luck
Abhijit Received on Tue Aug 19 1997 - 00:00:00 CDT