oracle sql判断语句有关问题

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_successselect 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

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