|
Something I would like to try is building a temp table and just comparing original table to the temp table... Dont know how to do this in informix though.... Here is a sketch.
delete Table1
from origtable Table1, temp_table Table2
where Table1.col2 = Table2.col2
and Table1.col1 > table2.col2
|