Casesql 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: sql CASE
/*CASE statements are used to create different outputs and is
used by SQL as a way to handle if-then logic.*/
SELECT column_name,
CASE
WHEN condition THEN
WHEN condition THEN
ELSE
END
FROM table_name;