Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » OperatorsRSS Feeds

ANY operator

Posted By: Adelaide Fischer     Category: Oracle     Views: 2054

This article explains about using ANY operator with example.

Customer - orders - salespeople database

ANY operator

- takes all values produced by the sub-query,and evaluates to TRUE if ANY of them equal the city values of the current row of the outer query.

Find salespeople with customers located in their cities.

SELECT * FROM Salespeople WHERE city = ANY(SELECT city FROM Customers);

  
Share: 

 
 
 

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

Adelaide Fischer
Adelaide Fischer author of ANY 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!