创建临时表

with d as(
select * from A

)
select * from d

原文地址:https://www.cnblogs.com/mobies/p/12035115.html