回答編集履歴
1
調整
answer
CHANGED
@@ -3,7 +3,8 @@
|
|
3
3
|
```SQL
|
4
4
|
SELECT
|
5
5
|
NAME,
|
6
|
-
CASE FLG1 WHEN
|
6
|
+
CASE FLG1 WHEN 0 THEN FLG2 ELSE 1 END AS RESULT1
|
7
7
|
FROM HOGE1
|
8
8
|
WHERE FLG1 IN ('0','1') AND YYMMDD IN('20180101','20180202')
|
9
|
-
```
|
9
|
+
```
|
10
|
+
※微調整しました
|