Home -> Usenet -> comp.databases.oracle -> Re: Please help on SQL

Re: Please help on SQL

From: Burnett <burnett_at_burnettms.demon.co.uk>
Date: 1998/03/25
Message-ID: <890864343.19871.0.nnrp-03.c1ed0717_at_news.demon.co.uk>#1/1 








Try;



SELECT DISTINCT foo1.a, foo1.b


FROM    foo f1,

                foo f2
WHERE
                f001.a = f002.a AND
                f001.b = f002.b AND
                f001.rowid != f002.rowid /* To prevent rows mathing them


selves */



The statement reads (in English)



Select foo column a and foo column b from foo where there is another row
with an itdntial value of in column a and column b.
Received on Wed Mar 25 1998 - 00:00:00 CET












Original text of this message