Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Query

SQL Query

From: Mads Kristiansen <mads.kristiansen_at_get2net.dk>
Date: Tue, 9 Nov 1999 11:06:28 +0100
Message-ID: <808rk6$dll$1@news.inet.tele.dk>


Hi,

How would one best do the following in SQL:

I have a table like this:

id product_id service_id

1    10                 3
2    11                 3
3    11                 5
4    12                 5
5    13                 5

.
.
.

Product 11 has 2 services as you can see. How could I identify all other products in that table with the same exact two services. Not more or not less services...

Received on Tue Nov 09 1999 - 04:06:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US