sql - 基于带有 'WITH'子句的SELECT的 View

Question

我选择了'WITH'子句:

with 
alias1 as (select...),
alias2 as (select ... from alias1),
alias3 as (select col1, col2 ... from alias2)
select col1,col2 from alias3 

我尝试使用以下方法创建 View :

create view ex_view as (
with 
alias1 as (select...),
alias2 as (select ... from alias1),
alias3 as (select col1, col2 ... from alias2)
select col1,col2 
from alias3
)

当我尝试执行此create语句时，“不支持使用WITH子句”

如何适本地基于我的选择语句创建 View ？

Answer 1

尝试删除括号:

create view ex_view as
with 
    alias1 as (select...),
    alias2 as (select ... from alias1),
    alias3 as (select col1, col2 ... from alias2)
from alias3;