I have column type of INT, I want to select 1 if it contains 1 and 0 otherwise. I know only way to do it using CASE:
CASE WHEN val=1 THEN 1 ELSE 0
What other approaches there is to achieve the same result?
4 Answers
Related
I have column type of INT, I want to select 1 if it contains 1 and 0 otherwise. I know only way to do it using CASE:
CASE WHEN val=1 THEN 1 ELSE 0
What other approaches there is to achieve the same result?