if then in sql 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

Example 3: if else sql

IF Boolean_expression
BEGIN
    -- Statement block executes when the Boolean expression is TRUE
END
ELSE
BEGIN
    -- Statement block executes when the Boolean expression is FALSE
END

Example 4: if in sql

SELECT 
  IF(500<1000, "YES", "NO");