with as 临时表的用法

1、层层嵌套作用：可以在PL/SQL工具里面试下哦

注意只用一个with，其他的套表要用英文“ 逗号，”隔开，最后还要配上主代码select语句

举个栗子：

with A as(select 11 as a,22 as b,33 as c from dual)

,B as (select * from A )

,C as (select * from B )

,D as (select * from C )

select * from D

2、正常的场景作用：相当于临时表的的作用；with   A as （select from 表） select * from A

举个栗子吧：

with A as (select * from emp)

select * from A