Select statement with condition

Question

I have the following tables:-

Now I get the following result:-

Basically, I want if Code in ('A') then Code_Respon and if Code in ('B') then Code_Respon. How to write this query?

Thanks in Advance

Answer 1

Hi @chuck DM

Your description confuses me. I am not sure if this is what you want.

create table test(Code char(1),Code_Respon varchar(20),Code_share varchar(10));
insert into test values
('A','R101','S11'),
('B','R1001','S12'),
('A','R201','S13'),
('C','R101','S14');

select Code,case when Code in ('A','B') then Code_Respon end Code_Respon,Code_share from test;

Output:

Best regards,

Percy Tang