select * from ${if(AA = 1,"one",if(BB = 1 || BB = 3 , 'two' ,if(BB = 2 || BB = 4,'TH','fr')))}
这个SQL有四个临时表,如何写呢，页面报错
我的不报错呀，你是不是上面也错了
with ONE AS
(
SELECT SYSDATE FROM DUAL
),
TWO AS
SELECT SYSDATE-1 FROM DUAL
TH AS
SELECT SYSDATE-2 FROM DUAL
FR AS
SELECT SYSDATE-3 FROM DUAL
)
select * from ${if(AA = 1,"ONE",if(BB = 1 || BB = 3 , 'TWO' ,if(BB = 2 || BB = 4,'TH','FR')))}
报什么错
1min目标场景问卷
立即参与
