I am using a case statement like below:
(Case Id when '5' then value end) as 'A'
(Case Id when '6' then value end) as 'B'
This is also returning null values, which I want to remove or exclude. How can I do that?
I am using a case statement like below:
(Case Id when '5' then value end) as 'A'
(Case Id when '6' then value end) as 'B'
This is also returning null values, which I want to remove or exclude. How can I do that?