「SQL」CASE文で条件分岐を行うサンプル
書式
CASE 値1
WHEN 値2 THEN 結果
[ELSE 結果]
END
使用例
SELECT
CASE name
WHEN 'A001' THEN 'red'
WHEN 'B002' THEN 'blue'
ELSE 'other'
END as CFT
from USERTBL;
SELECT
CASE name
WHEN 'A001' THEN 'red'
WHEN 'B002' THEN 'blue'
ELSE 'other'
END as CFT
from USERTBL;
SELECT CASE name WHEN 'A001' THEN 'red' WHEN 'B002' THEN 'blue' ELSE 'other' END as CFT from USERTBL;