回答編集履歴

1

Fix bug, Simplify

2020/06/29 11:46

投稿

y_shinoda
y_shinoda

スコア3272

test CHANGED
@@ -6,7 +6,7 @@
6
6
 
7
7
  ```sql
8
8
 
9
- SELECT XYZ.A, XYZ.B, XYZ.C, XYZ.D, XYZ.# = INLINE.# AS ※1
9
+ SELECT XYZ.#, XYZ.A, XYZ.B, XYZ.C, XYZ.D, INLINE.# AS ※1
10
10
 
11
11
  FROM XYZ
12
12
 
@@ -34,15 +34,15 @@
34
34
 
35
35
  1|1000|201|002|1A|1
36
36
 
37
- 2|1000|202|001|1A|1
37
+ 2|1000|202|001|1A|2
38
38
 
39
- 3|1000|202|002|1A|1
39
+ 3|1000|202|002|1A|3
40
40
 
41
- 4|1000|203|001|1A|1
41
+ 4|1000|203|001|1A|4
42
42
 
43
- 5|1000|204|001|2A|0
43
+ 5|1000|204|001|2A|NULL
44
44
 
45
- 6|1000|204|002|2A|0
45
+ 6|1000|204|002|2A|NULL
46
46
 
47
47
 
48
48