SQL Case Statement refering other column value

Question

I have table like Which has column A & B

      A            B
      1            9
      1            8
      2            7
      2            5

I want to write query.

  Select case when B = 9 then A = 'X', when A = 2 then 'Y' end as A

Is it possible in SQL. Please guide me

Possible duplicate http://stackoverflow.com/questions/14189216/case-in-select-statement — mituw16, May 15 '14 at 14:08
Don't do A = 'X', instead write 'X'. The query will be `Select case when B = 9 then 'X' when A = 2 then 'Y' End as A` — Roopesh, May 15 '14 at 14:15

score 0 · Answer 1 · answered May 14 '16 at 09:23

0

Try this:

SELECT  
    CASE WHEN B = 9 THEN 'X'
         WHEN A = 2 THEN 'Y'
    END ,
    A ,
    B
FROM    dbo.tblTest;

answered May 14 '16 at 09:23

1 Answers1