Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: De-duplication of large table
Nope. Just one table called 'test', but with two different aliases 'a' and
'b'.
Dave wrote in message <813agt$5d2$1_at_lure.pipex.net>...
>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 - 06:39:41 CST