标题: SQL数据集with子查询中使用参数报错 [打印本页] 作者: flyzhi 时间: 2023-11-1 18:03 标题: SQL数据集with子查询中使用参数报错 SQL数据集with子查询中使用参数报错
SQL语句结构大概如下:
with tab as (
select
...
from table
where 1=1
and a> ?{a}
and b <=?{b}
)
,hz as(
select
...
from tab
group by
...
)
select
...
from hz a
left join hz b
on ...
where c = ?{c}