本文介绍如何利用with临时表提高SQL查询效率，通过创建虚拟表并进行联接操作来简化复杂查询过程。
--使用with临时表
with
q1 as (select 1+1.5 as P from dual),
q2 as (select 3*5 as Q from dual),
q3 as (select P,Q,P*Q from q1,q2)
select * from q3;
with
q1 as (select 1+1.5 as P from dual),
q2 as (select 3*5 as Q from dual),
q3 as (select P,Q,P*Q from q1,q2)
select * from q3;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
