Re: Strange ROWID problem

In stead of testing for a.row_id <> b.row_id, try a.row_id > b.row_id. This change will have the effect of the row with the smallest row_id will not be deleted.

Rgds
John Bester
johnb_at_iconnect.co.za

John Strange wrote in message <6ofhpk$df6$2_at_relay1.dsccc.com>...
>
>delete from mytable a
> where exists (select 'x'
> from mytable b
> where a.primary_key = b.primary_key
> and a.rowid <> b.rowid
> )
Received on Wed Jul 15 1998 - 07:33:01 CDT