作用
with语句相当于建立了一张或多张临时虚拟表,再用查询语句从虚拟表中查询数据,虚拟表用完即销毁
语句格式
with
A as (select X1,Y1 from table1),-- 不能嵌套with语句
B as (select s.x2,t.x1 from t2 s,t3 t),
......
M as (select a.x3,b.s2 from t3 a,t8 b)
select ...... -- 实际查询语句,最后的结果,必须用select语句