Oracle subquery syntax and examples - Handy tips for oracle database users

Simple examples to learn about the Oracle subquery statement. ... SQL> select ename, (select max(sal) from emp) "maxsal" , sal, ((select max(sal) from emp ) - sal ) "difference" from emp; ENAME maxsal SAL ...

www.oracle-database-tips.com