FPSBASE.BLD_REMOVE_DUPLICATES

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_REMOVE_DUPLICATES

This view builds a query to update a column which is part of a primary or unique key. It disables the constraint, does the update, removes the duplicates, and enables the constraint. If you are just looking for the query template to remove duplicate rows manually, which is useful if you are trying to drop a column from a unique constraint, here it is: delete from TABLE where rowid in ( select rowid from ( select rowid, count(*) over (partition by COLUMN) as n, min(rowid) over (partition by COLUMN) as m from TABLE ) where n > 1 and rowid != m );