17,382
社区成员




WITH tmp (xxx, xxx, ...) AS (
SELECT ... FROM ...
)
SELECT * FROM tmp;
with t1 as
(select * from scott.emp),
t2 as
(select * from scott.dept)
select * from t1, t2 where t1.deptno = t2.deptno;
WITH tmp (xxx, xxx, ...) AS (
SELECT ... FROM ...
), othertmp(xxx, xxx, ...) AS (
SELECT ... FROM ...
)
SELECT * FROM othertmp;