Delete duplicates

Database
Enthusiast

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
Enthusiast

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 ...