「SQL」CASE文で条件分岐を行うサンプル

2021年5月2日

書式
CASE 値1
WHEN 値2 THEN 結果
[ELSE 結果]
END
使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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;

 

Server

Posted by arkgame