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 'A'
      WHEN (1+6 = 7) THEN 'B'
      WHEN (1+6 = 8) THEN 'C'
      ELSE 'D'
	END 
FROM DUAL;

-- OUTPUT: B

Example 2: end as sql

select 
case when ID in ('1', '2', '3')
then 'Jack'
else 'Jim'
end as Person
from Table.Names

select
case when ID in ('1', '2', '3')
then 'Jack'
else 'Jim'
end Person
from Table.Names

Tags:

Vb Example