SQL Server CASE WHEN式にASで別名を付ける方法
書式
CASE WHEN 条件式 THEN 値
END AS 別名
CASE式にはAS句で別名を付けることができます。
使用例
SELECT CASE
WHEN month IN ('03', '04', '05') THEN '春'
WHEN month IN ('06', '07', '08') THEN '夏'
WHEN month IN ('09', '10', '11') THEN '秋'
WHEN month IN ('12', '01', '02') THEN '冬'
END AS season
FROM USER_TBL;
SELECT CASE
WHEN month IN ('03', '04', '05') THEN '春'
WHEN month IN ('06', '07', '08') THEN '夏'
WHEN month IN ('09', '10', '11') THEN '秋'
WHEN month IN ('12', '01', '02') THEN '冬'
END AS season
FROM USER_TBL;
SELECT CASE
WHEN month IN ('03', '04', '05') THEN '春'
WHEN month IN ('06', '07', '08') THEN '夏'
WHEN month IN ('09', '10', '11') THEN '秋'
WHEN month IN ('12', '01', '02') THEN '冬'
END AS season
FROM USER_TBL;