我如何编写这样的查询语句:
我该如何编写以下查询语句:
with t1 as
(
select id
from table1
),
RECURSIVE t2(
select * from t2
union
...
)
目前还不允许吗?
我该如何编写以下查询语句:
with t1 as
(
select id
from table1
),
RECURSIVE t2(
select * from t2
union
...
)
目前还不允许吗?
recursive
需要紧跟在 WITH
后面,无论您将递归 CTE 放在何处:
with recursive t1 as
(
select id
from table1
), t2 (
select *
from t2
union
...
)
...