teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

1

訂正

2018/10/29 13:42

投稿

nullpon
nullpon

スコア5739

answer CHANGED
@@ -1,9 +1,9 @@
1
1
  こんな漢字で、
2
2
  ```SQL
3
3
  SELECT
4
- CASE WHEN "区分A" = 0 AND "区分B" = 0 THEN "売上高 "ELSE 0 END AS "売上高種別1"
4
+ CASE WHEN "区分A" = '0' AND "区分B" = '0' THEN "売上高 "ELSE 0 END AS "売上高種別1"
5
- ,CASE WHEN "区分A" = 0 AND "区分B" = 1 THEN "売上高" ELSE 0 END AS "売上高種別2"
5
+ ,CASE WHEN "区分A" = '0' AND "区分B" = '1' THEN "売上高" ELSE 0 END AS "売上高種別2"
6
- ,CASE WHEN "区分A" = 1 AND "区分B" = 0 THEN "売上高" ELSE 0 END AS "売上高種別3"
6
+ ,CASE WHEN "区分A" = '1' AND "区分B" = '0' THEN "売上高" ELSE 0 END AS "売上高種別3"
7
- ,CASE WHEN "区分A" = 1 AND "区分B" = 1 THEN "売上高" ELSE 0 END AS "売上高種別4"
7
+ ,CASE WHEN "区分A" = '1' AND "区分B" = '1' THEN "売上高" ELSE 0 END AS "売上高種別4"
8
8
  (以下略)
9
9
  ```