语法就是 可以支持多个:
with t1 as (
...
),t2 as (
..
)
t3 as ..
select ..
例子:
with t as (select * from emp where depno=10)
select * from t where empno=xxx
语法就是 可以支持多个:
with t1 as (
...
),t2 as (
..
)
t3 as ..
select ..
例子:
with t as (select * from emp where depno=10)
select * from t where empno=xxx