好记性不如烂笔头。

sql with as临时视图

with as 是临时视图的语法:
比如:
with qry_a as (select * from table_a )
select * from qry_a ;