Hi,
我们用到的db2 的with as语句如下,目前druid不支持这个语句,是否可以支持
WITH rpl(INNER_ROLE_CD,INNER_ROLE_CD_1) as
(select root.INNER_ROLE_CD,root.INNER_ROLE_CD_1
from pl_0007 root
where root.INNER_ROLE_CD_1= ?
union all
select child.INNER_ROLE_CD,child.INNER_ROLE_CD_1
from rpl parent, pl_0007 child
where parent.INNER_ROLE_CD = child.INNER_ROLE_CD_1 )
select distinct rpl.INNER_ROLE_CD,rpl.INNER_ROLE_CD_1 from rpl;
1条答案
按热度按时间nvbavucw1#
希望提供with as 语句支持