CASE文
例)idが100以上と100未満の会員を性別ごとに集計
SELECT
CASE
WHEN sex_code = 1 THEN '男'
WHEN sex_code = 2 THEN '女'
ELSE '不明'
END,
SUM (
CASE
WHEN id >= 100 THEN 1 ELSE 0
END
) as "100以上",
SUM (
CASE
WHEN id < 100 THEN 1 ELSE 0
END
) as "100未満"
FROM
mst_member
GROUP BY
sex_code※asの後は、文字列のみなら""で囲わなくても可。''は常に使用不可。
例)as 未満 … OK
as "未満" … OK
as 100未満 … NG ⇒ as "100未満"
as '100未満' … NG ⇒ as "100未満"
問合せ結果
case | 100以上 | 100未満 |
不明 | 6 | 0 |
男 | 1 | 2 |
女 | 0 | 1 |