回答編集履歴
2
改行ミス
test
CHANGED
@@ -86,4 +86,6 @@
|
|
86
86
|
|
87
87
|
) C
|
88
88
|
|
89
|
-
ON C.NUM = A.NUM
|
89
|
+
ON C.NUM = A.NUM
|
90
|
+
|
91
|
+
```
|
1
サブクエリに ORDER BY を追加
test
CHANGED
@@ -30,6 +30,10 @@
|
|
30
30
|
|
31
31
|
PLACE = '日本'
|
32
32
|
|
33
|
+
ORDER BY
|
34
|
+
|
35
|
+
NAME
|
36
|
+
|
33
37
|
) A
|
34
38
|
|
35
39
|
FULL JOIN
|
@@ -49,6 +53,10 @@
|
|
49
53
|
WHERE
|
50
54
|
|
51
55
|
PLACE = '中国'
|
56
|
+
|
57
|
+
ORDER BY
|
58
|
+
|
59
|
+
NAME
|
52
60
|
|
53
61
|
) B
|
54
62
|
|
@@ -72,8 +80,10 @@
|
|
72
80
|
|
73
81
|
PLACE = 'イタリア'
|
74
82
|
|
83
|
+
ORDER BY
|
84
|
+
|
85
|
+
NAME
|
86
|
+
|
75
87
|
) C
|
76
88
|
|
77
|
-
ON C.NUM = A.NUM
|
89
|
+
ON C.NUM = A.NUM```
|
78
|
-
|
79
|
-
```
|