An example of an Oracle all subquery

Problem:
Check out the employee's name, job, and salary, which are higher than the salary of all sales staff.

Analysis:
Any can represent arbitrary, but this problem requires a higher salary than all salespeople, then use a different keyword all.
All is used with the relational operator to represent comparisons with all elements in a subquery.

Code Demo: All subqueries

<span style= "FONT-SIZE:18PX;" >SQL> Select Ename,job,sal from emp  2  where Sal>all (select SAL from emp where job= ' salesman ')  3
  
   /</span>
  

Code parsing:
>all: Larger than all values in the subquery result, that is, larger than the maximum value in the subquery result.
<all is smaller than the minimum value.

The in and not in operators can also be used for subqueries.

An example of an Oracle all subquery