when statement in SQL code example
Example 1: 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 2: how to write if case in select query in select statement
SELECT player_name,
CASE WHEN year = 'FR' AND position = 'WR' THEN 'frosh_wr'
ELSE NULL END AS sample_case_statement
FROM benn.college_football_players