5回答

• 

  qq_s星空_0

  2019-01-10 14:11:27

  select value,decode(value,'A','OK','B','NO','GOOD')AS 结果 from T;
  

  0 0
• 

  慕数据7318166

  2018-12-20 13:57:24

  select value, decode(value,'A','OK','B','NO','GOOD') as 结果 from T;

  
  

  0 0
• 

  STFocus

  2018-01-13 22:57:06

  
  

  SELECT value, 
  CASE value WHEN 'A' THEN 'OK'
  WHEN 'B' THEN 'NO'
  ELSE 'GOOD'
  END
  AS result
  FROM T;

  or
  

  SELECT value, 
  DECODE(value,'A','OK',
               'B','NO',
               'GOOD')
  AS result
  FROM T;

  
  

  0 1
• 

  沐风_0008

  2017-03-25 21:54:08

  select value,decode(value,'A','OK','B','NO','GOOD') as 结果 from T;

  0 0
• 

  慕莱坞1574965

  2017-03-09 04:39:28

  select value, case value when 'A' then 'OK'

     when 'B' then 'NO'

    else 'GOOD'

    end

    as 结果

    from T;

  
  

  0 0