Delete duplicates

Database
N/A

Delete duplicates

How to delete duplicate records using sql assistant query without using any other object other than the source table itself?

Is it possible to use rownum and groupby?
1 REPLY

Re: Delete duplicates

I think you can do it using rowid, if it's enabled in the dbscontrol...

but there's no straightforward way if I remember correctly other than using an intermediate table ...