SQL_ANY_SUBQUERIES1
SQL :

select e.empno, e.ename, e.job, e.sal from emp e where e.sal > ANY (select e2.sal from emp e2 where e2.job = 'MANAGER')

ORACLE

POSTGRESQL

MySQL