Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » OperatorsRSS Feeds

ALL operator

Posted By: Lois Schmidt     Category: Oracle     Views: 3350

This article explains about using All operator with example.

Customer - orders - salespeople database

ALL operator

- With ALL ,the predicate is TRUE, if every value selected by the sub-query satisfies the condition in the predicate of the outer query.

Find all customers whose ratings are higher than the ratings of every customers in "ahmd".

SELECT * FROM Customers WHERE rating > ALL (SELECT rating FROM Customers WHERE city='ahmd');

 

  
Share: 

 
 
 

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

Lois Schmidt
Lois Schmidt author of ALL 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!