回答編集履歴

1

訂正

2018/10/29 13:42

投稿

nullpon
nullpon

スコア5737

test CHANGED
@@ -4,13 +4,13 @@
4
4
 
5
5
  SELECT
6
6
 
7
- CASE WHEN "区分A" = 0 AND "区分B" = 0 THEN "売上高 "ELSE 0 END AS "売上高種別1"
7
+ CASE WHEN "区分A" = '0' AND "区分B" = '0' THEN "売上高 "ELSE 0 END AS "売上高種別1"
8
8
 
9
- ,CASE WHEN "区分A" = 0 AND "区分B" = 1 THEN "売上高" ELSE 0 END AS "売上高種別2"
9
+ ,CASE WHEN "区分A" = '0' AND "区分B" = '1' THEN "売上高" ELSE 0 END AS "売上高種別2"
10
10
 
11
- ,CASE WHEN "区分A" = 1 AND "区分B" = 0 THEN "売上高" ELSE 0 END AS "売上高種別3"
11
+ ,CASE WHEN "区分A" = '1' AND "区分B" = '0' THEN "売上高" ELSE 0 END AS "売上高種別3"
12
12
 
13
- ,CASE WHEN "区分A" = 1 AND "区分B" = 1 THEN "売上高" ELSE 0 END AS "売上高種別4"
13
+ ,CASE WHEN "区分A" = '1' AND "区分B" = '1' THEN "売上高" ELSE 0 END AS "売上高種別4"
14
14
 
15
15
  (以下略)
16
16