Skip to Main Content

Oracle Database Discussions

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!

Using the minus operator

1002499Apr 11 2013 — edited Apr 11 2013
I am very new to oracle and am working with the minus operator to run a query. I could use some help!

Here is the query I am working on:

select suppliername, partname
from quote
where partname = 'hammer'
minus
select suppliername, partname
from quote
where partname = 'hammer';

HOW DO I GET THE QUERY TO DISPLAY ONLY THE ROWS OF SUPPLIERNAMES THAT SUPPLY ONLY HAMMERS?
I WOULD GREATLY APPRECIATE SOME CLARIFICATION.
This post has been answered by riedelme on Apr 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2013
Added on Apr 11 2013
11 comments
533 views