All Forums Database
TdMan 91 posts Joined 01/07
07 Mar 2008
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?

joedsilva 505 posts Joined 07/05
07 Mar 2008

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

You must sign in to leave a comment.