There are two variables in our database called OB
and B2B_OB
. There are EP codes and each EP may have one of the following 4 combinations:
EP OB B2B_OB
--- -- ------
3 X
7 X
11
14 X X
What I want to do is to combine the X's in the fetched list so that I can have A or B value for a single EP. My conditions are:
IF (OB IS NULL AND B2B_OB IS NULL) THEN TYPE = A
IF (OB IS NOT NULL O开发者_运维技巧R B2B_OB IS NOT NULL) THEN TYPE = B
The list I want to fetch is like this one:
EP TYPE
--- ----
3 B
7 B
11 A
14 B
How can I do this in my query? TIA.
(EDIT: corrected AND to OR)
Here's a solution (syntax tested on postgres, but from what I read it should be the same)
select ep,
case
when ob is null and b2b_ob is null then a
when ob is not null or b2b_ob is not null then b
else null
end as type
from table;
Note: else null is redundant but only wanted to emphasize the default else case.
精彩评论