PLSQL_基础系列10_子查询WITH AS（案例）

select e.ename
  from emp e
 where e.deptno in (select d.deptno from dept d where d.deptno = 10);

with a as
 (select e.ename, e.deptno from emp e)
select a.ename
  from a
 where a.deptno in
       (with b as (select d.deptno from dept d where d.deptno = 10)
         select * from b
        );

with a as
 (select e.ename, e.deptno from emp e),
b as
 (select d.deptno from dept d where d.deptno = 10)
select a.ename from a where a.deptno in (select * from b);