Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » OperatorsRSS Feeds

MINUS OPERATOR

Posted By: Bourke Fischer     Category: Oracle     Views: 3206

This article explains about using MINUS OPERATOR with example.

Customer - orders - salespeople database

MINUS OPERATOR

Find all the salespeople who have not got any orders.

(SELECT snum FROM Salespeople)
MINUS
(SELECT snum FROM Orders);


  
Share: 


Didn't find what you were looking for? Find more on MINUS OPERATOR Or get search suggestion and latest updates.

Bourke Fischer
Bourke Fischer author of MINUS OPERATOR is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!