Re: exclude multiple rows based on values in one row?

From: Ryan <rgaffuri_at_cox.net>
Date: Thu, 29 May 2003 00:11:56 GMT
Message-ID: <gfcBa.120829$823.45619@news1.east.cox.net>

what do you mean by 'exclude'? Do you want to delete duplicate rows based on a value in 1 specific field?
is the field the primary key? there is an easy way to do that on asktom.oracle.com

its something like

delete from tab
where rownum = (select min(rownum)

                             from tab
                             where something or other that I forget how to

do.

"Jack Silvey" <depifster_at_yahoo.com> wrote in message news:25c7944d.0305281528.7c48effd_at_posting.google.com...
> anyone know a good way to exclude multiple related rows based on the
> values in one row?
>
>
> thanks,
>
> Jack
Received on Wed May 28 2003 - 19:11:56 CDT