|
最佳回答 |
0
|
WZLLLv2见习互助发布于2021-3-17 14:11
|
case when then when then end
|
|
|
|
最佳回答 |
0
|
小歆嵩Lv7初级互助发布于2021-2-4 14:32
|
|
|
|
|
最佳回答 |
0
|
krystal033Lv7高级互助发布于2021-2-4 14:35(编辑于 2021-2-4 14:36)
|
select
case when F4111.ILMCU=' 1000194K' AND ILTRDJ>120100 AND ILDCT='IC'AND ILLOCN <>'NY' then F58E4101.IM58PD
case when ....
else .....
end
from tab ......自己替换
|
|
|
|
最佳回答 |
0
|
snrtuemcLv8专家互助发布于2021-2-4 14:49(编辑于 2021-2-4 14:50)
|
select case when F4111.ILMCU='1000194K' AND ILTRDJ>120100 AND ILDCT='IC'AND ILLOCN <>'NY' then F58E4101.IM58PD
else F58E0036.CRSREF01 end from 表 where F58E0036.PZDL0='P09'
|
|
|
|
最佳回答 |
0
|
秋风影Lv6见习互助发布于2021-2-4 15:50
|
select case when F4111.ILMCU='1000194K' AND ILTRDJ>120100 AND ILDCT='IC'AND ILLOCN <>'NY' then F58E4101.IM58PD else F58E0036.CRSREF01 end from (select * from 表) where F58E0036.PZDL0='P09'
|
|
|