回答編集履歴
1
訂正
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
|
|