select語句又稱？

With as 就是將一個子查詢的結果作為一張臨時表，下面接著寫select語句可以通過別名直接使用

語法：

針對一個別名

with tmp as (select * from tb_name)

針對多個別名

with

tmp as (select * from tb_name),

tmp2 as (select * from tb_name2),

tmp3 as (select * from tb_name3),