1、select case when service_code=1 or service_code=3 then response_success else 'NA' end response_success  ,
case when service_code=1 or service_code=3 then user_success else 'NA' end user_success  from tb;
2、select response_success，user_success from tb where service_code in(1,3)
union all 
  select 'NA','NA' from tb where service_code not in(1,3)

------解决方案--------------------
如果service_code=1或者service_code=3时，response_success，user_success为表tb中内容
如果service_code！=1或者service_code！=3时，response_success，user_success的内容为NA
写到二个SQL条件矛盾吧,
第二个是不是
如果service_code！=1并且!!!!service_code！=3时???
select  case when service_code in(1,3) then response_success else 'NA' end response_success,
case when service_code in(1,3) then user_success else 'NA' end user_success  
from  tb

------解决方案--------------------
探讨

SQL code

1、select case when service_code=1 or service_code=3 then response_success else 'NA' end response_success  ,
case when service_code=1 or service_code=3 then user_success else 'NA' end user……


------解决方案--------------------
SQL code

--
with tb as(select '1' service_code, 'true' response_success, 'false' user_success union all
                    select '3' service_code, 'false' response_success, 'true' user_success union all
                    select '2' service_code, 'true' response_success, 'true' user_success union all)

select service_code, decode(service_code, '1', response_success, '3', response_success, 'NA'),decode(service_code, '1', user_success, '3', user_success, 'NA') from tb
------------------------------------------
service_code  response_success  user_success
'1'                    'true'                          'false'
'3'                    'false'                          'true'
'2'                     'NA'                             'NA'

--ps:你的第2个条件应该是并且的关系

------解决方案--------------------
楼主的逻辑确实有问题啊 哈哈啊
case when

------解决方案--------------------
SQL code

--service_code，response_success，user_success
select case service_code when not in (1,3) then 'NA' else response_success end,case service_code when not in (1,3) then 'NA' else user_success end from tb;

------解决方案--------------------
SQL code
select (case when service_code in (1,3) then response_success else 'NA' end) as response_success,
       (case when service_code in (1,3) then user_success     else 'NA' end) as user_success
 from tb;

------解决方案--------------------
探讨


SQL code
select (case when service_code in (1,3) then response_success else 'NA' end) as response_success,
       (case when service_code in (1,3) then user_success     else 'NA' end) as user_succes……


------解决方案--------------------
select
(case when service_code in (1,3) then response_success else 'NA' end)as response_success,
(case when service_code in (1,3) then user_success  else 'NA' end) as user_success


------解决方案--------------------