Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Selection criteria

487726Jun 19 2006 — edited Jun 19 2006
I have 10 different products in the product_detail table. Each of these products is a purchased one, so we have the customer information lying in different columns of the same table. Each product purchased is listed in the table. If a customer has purchased 4 different products, there are 4 rows for that customer and customer_Id is repeated 4 times. However each purchase is considered unique so a contract_ID is unique. So any time the combination od customer_Id and Contract_Id is unique throughout the table.

For example,
Customer_1 has 4 different contracts contract_1, contract_2, contract_3, contract_4). Contact_1 could be a desktop,Contact_1 could be a server,Contact_1 could be a Laptop, Contact_1 could be a desktop again. For each row this information is given column Item.

Question: How do I separate out the customers who have only one contract and the item is "LAPTOP".
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2006
Added on Jun 19 2006
5 comments
151 views