CASE WHEN SQL SERVER 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
Change query output depending on conditions.
Example: Returns users and their subscriptions, along with a new column
called activity_levels that makes a judgement based on the number of
subscriptions.
SELECT first_name, surname, subscriptions
CASE WHEN subscriptions > 10 THEN
WHEN Quantity BETWEEN 3 AND 10 THEN
ELSE
END AS activity_levels
FROM users;
Example 3: 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;