select文で
CASE col
WHEN 0 THEN col
WHEN 1 THEN col2
END AS colname,
CASE
WHEN col IS NULL THEN col
ELSE col2
END AS colname2
case 対象
when 条件 then 結果
when 条件2 then 結果2
end (as 別名)
select文で
CASE col
WHEN 0 THEN col
WHEN 1 THEN col2
END AS colname,
CASE
WHEN col IS NULL THEN col
ELSE col2
END AS colname2
case 対象
when 条件 then 結果
when 条件2 then 結果2
end (as 別名)