let say i do select score from table1
. this will return result
score
----
0
20
40
how to use case, to change the output to if 0->strongly not agree 20->agree 40->very agreed
See Question&Answers more detail:oslet say i do select score from table1
. this will return result
score
----
0
20
40
how to use case, to change the output to if 0->strongly not agree 20->agree 40->very agreed
See Question&Answers more detail:osThis does a simple translation of fixed values:
select score
, case score
when 0 then 'strongly not agree'
when 20 then 'agree'
when 40 then 'very agreed'
else 'don''t know'
end as txt
from your_table
/
If you are working with ranges the syntax is slightly different:
select score
, case
when score between 0 and 19 then 'strongly not agree'
when score between 20 and 39 then 'agree'
when score >= 40 then 'very agreed'
else 'don''t know'
end as txt
from your_table
/
The ELSE branch is optional but I have included it to handle NULLs or unexpected values. If your data model enforces the appropriate constraints you might not need it.