Re: newbie: select statement question

#1

"P. Griffioen" wrote:

Quote:

Hello,

I am having troubles figuring out how to get the following result with a sql
statement:

suppose I have two columns (A and B), populated with the following data :

A B
1 1
1 2
1 3
1 4
2 1
2 2
2 3
3 1
3 2
3 3

Now, I want to get a selection of A and B where the value of B is in all
selections of A(1,2,3,4).

In the example above I want a return of all records -except- of the
combination 1,4 (because 4 is only present in A(1) and not in the other
values of A).

I have tried some subselects and a joining of the same table; but i don't
think that is the right approach.

Thank you in advance for any hints.

best regards,
Peter

SELECT ...
FROM ...
WHERE ...
AND ...
AND ...
AND ...

Provided you can hard-code 1 through 4. If the number is dynamic and there are
considerations about missing numbers so that you can't just use BETWEEN ... you
are writing a PL/SQL procedure.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: newbie: select statement question

comp.databases.oracle.misc comp.databases.oracle.misc

Re: newbie: select statement question - 07-10-2003 , 03:05 PM