Re: De-duplication of large table

oops change first sql statement to read

delete from test a
where rowid = ( select max(rowid)

                             from test b
                              where b.rec_num = a.rec_num ) and
            rowid <> ( select min(rowid)
                             from test b
                              where b.rec_num = a.rec_num )