sql - case when in case when 作为计算列
问题描述
过去我得到了论坛的大力支持,希望有人可以帮助我解决我的问题,即
我有一个案例,当我想将它作为一个列返回时,但在某个地方出现了一个错误,''
但我看不到它。欢迎任何帮助。
谢谢
CASE
WHEN SUBSTRING(a.DET_NOMINALDR,3,2) =’BS’
THEN 0
ELSE a.DET_NOMINALDR
END as NEW_DET_NOMINALDR
WHEN SUBSTRING(a.DET_NOMINALCR,3,2) =’BS’
then 0
else a.DET_NOMINALCR
end as NEW_DET_NOMINALCR
WHEN NEW_DET_NOMINALDR = 0
THEN NEW_DET_NOMINALCR
ELSE NEW_DET_NOMINALDR AS NOMINAL
END
解决方案
您的子字符串缺少右括号
select
(
Case when (
(Case when (substring(a.DET_NOMINALDR,3,2)) ='BS' then '' else a.DET_NOMINALDR end) ='') then
(Case when (substring(a.DET_NOMINALCR,3,2)) ='BS' then '' else a.DET_NOMINALCR end)
else (Case when (substring(a.DET_NOMINALDR,3,2)) ='BS' then '' else a.DET_NOMINALDR end) end) as Nominal
推荐阅读
- c# - Microsoft Graph: Get Children of all Child Groups (.NET)
- plotly - plotly (px) animation_frame error with datetime not being accepted
- javascript - Ionic Input file capture file or memory is saved on mobile
- docker - 是否可以在同一台机器上托管多个 aler9/rtsp-simple-server
- html - Relatively Scale Text Based on Window Size While Supporting Browser Zoom
- go - Check for empty inline struct
- javascript - NextJs Tailwind build (purge) removes all styling
- matlab - I can't find a legit reason on why this Matlab code takes a long time to compute, or it might not give out a result?
- lua - How can I fix this erroring Lua BTC Miner? (
- android - [Unhandled promise rejection: TypeError: error is not a function. (In 'error({]