I Want to write oracle sql cases with multiple conditions with multiple output values.
For instance,
SELECT A,B,
Case
When A In(default, non default, Deliquent) Then ('dl_vint','lw_vint','hg_vint')
from Application
-
Please provide sample data and desired results.Gordon Linoff– Gordon Linoff2021-06-11 11:30:17 +00:00Commented Jun 11, 2021 at 11:30
Add a comment
|
2 Answers
SQL queries support case expressions. An expression returns a single value. I assume that you want something like this:
select A, B,
(case when A = 'default' then 'dl_vint'
when A = 'non default' then 'lw_vint'
when A = 'Deliquent' then 'hg_vint'
end)
from Application
Comments
Like this
SELECT
A, B,
case A
when 'default' THEN 'dl_vint'
when 'non default' then 'lw_vint'
when 'Deliquent' then 'hg_vint'
end
from Application
