> --3. 可以在主查询的where select from having后面放置子查询
SQL> select empno,ename,(select job from emp where empno=7839)
2 from emp;
EMPNO ENAME (SELECTJO
---------- ---------- ---------
7369 SMITH PRESIDENT
7499 ALLEN PRESIDENT
7521 WARD PRESIDENT
7566 JONES PRESIDENT
7654 MARTIN PRESIDENT
7698 BLAKE PRESIDENT
7782 CLARK PRESIDENT
7788 SCOTT PRESIDENT
7839 KING PRESIDENT
7844 TURNER PRESIDENT
7876 ADAMS PRESIDENT
EMPNO ENAME (SELECTJO
---------- ---------- ---------
7900 JAMES PRESIDENT
7902 FORD PRESIDENT
7934 MILLER PRESIDENT
已选择14行。
SQL> select empno,ename,(select job from emp where empno=7839)
2 from emp;
EMPNO ENAME (SELECTJO
---------- ---------- ---------
7369 SMITH PRESIDENT
7499 ALLEN PRESIDENT
7521 WARD PRESIDENT
7566 JONES PRESIDENT
7654 MARTIN PRESIDENT
7698 BLAKE PRESIDENT
7782 CLARK PRESIDENT
7788 SCOTT PRESIDENT
7839 KING PRESIDENT
7844 TURNER PRESIDENT
7876 ADAMS PRESIDENT
EMPNO ENAME (SELECTJO
---------- ---------- ---------
7900 JAMES PRESIDENT
7902 FORD PRESIDENT
7934 MILLER PRESIDENT
已选择14行。