回答編集履歴

1

修正

2021/01/20 08:04

投稿

Orlofsky
Orlofsky

スコア16417

test CHANGED
@@ -1,14 +1,18 @@
1
1
  ```SQL
2
2
 
3
- SELECT ...
3
+ SELECT
4
4
 
5
- CASE WHEN rg_cd = store_cd
5
+ COL1
6
6
 
7
- THEN store_cd
7
+ , COL1
8
8
 
9
- ELSE 'NULL'
9
+ , CASE WHEN rg_cd = store_cd
10
10
 
11
+ THEN store_cd
12
+
13
+ ELSE 'NULL'
14
+
11
- END AS store_cd -- 追加
15
+ END AS store_cd -- 追加
12
16
 
13
17
  FROM ...
14
18