An example of OracleAny subquery

An example of OracleAny subquery

Problem:
Query the names, jobs, and salaries of employees with lower salaries than any salesperson ("SALESMAN") in the Emp table.
Analysis:
The salesperson has many records in the Emp table. The salaries of each person are not equal. If the condition "the salary is lower than the salary of any employee" is returned, the condition "the highest salary is lower" is returned.
If the subquery is used, multiple records are returned in the subquery. An error occurs when running with common Relational operators (>, <, and so on.
In this case, you need to use the keyword "ANY. ANY is placed behind the comparison operator, indicating "ANY.

Code Demonstration: ANY subquery

<Span style = "font-size: 18px;"> SQL> SELECT ENAME, JOB, SAL FROM EMP 2 WHERE SAL <ANY (SELECT SAL FROM EMP WHERE JOB = 'salesman ') 3/</span>

Code parsing:
<Any: it is smaller than any value in the subquery results, that is, it is smaller than the maximum value in the subquery results. Similarly,> any indicates it is bigger than the smallest value in the subquery results.