An example describes Oracle All subqueries, and oracleall subqueries.

An example describes Oracle All subqueries, and oracleall subqueries.

Problem:
The employee names, jobs, and salaries that are higher than the salaries of all salespeople are queried.

Analysis:
ANY can represent ANY, but this problem requires higher salaries than ALL salespeople, so we need to use another keyword "ALL.
ALL is used with Relational operators to compare ALL elements in subqueries.

Code Demonstration: 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: greater than ALL values in the subquery results, that is, greater than the maximum value in the subquery results.
<ALL indicates that the value is smaller than the minimum value.

Subqueries can also be operated using the IN and not in operators.