case when condition code example
Example 1: sql case
-- NOTE: this is for SQL-Oracle specifically
/*
NB: Please like Mingles444 post, I derived this from him/her
*/
-- syntax: (Retrieved from grepper:Mingles444)
CASE
WHEN condition1 THEN result1
WHEN condition2 THEN result2
WHEN conditionN THEN resultN
ELSE result
END
-- example:
SELECT
CASE
WHEN (1+6 = 6) THEN
WHEN (1+6 = 7) THEN
WHEN (1+6 = 8) THEN
ELSE
END
FROM DUAL;
-- OUTPUT: B
Example 2: end as sql
select
case when ID in (
then
else
end as Person
from Table.Names
select
case when ID in (
then
else
end Person
from Table.Names