Re: De-duplication of large table

My brain hurts. I don't understand this! Does this not mean having two tables?
If not, what's a and what's b ????
Help

Dave

no spam <no_at_spam.com> wrote in message
news:xf%Y3.32983$m4.112819766_at_news.magma.ca...
> 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 )
>
>
>
>
Received on Fri Nov 19 1999 - 04:58:17 CST