質問編集履歴
3
書式の改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,7 +12,7 @@
|
|
12
12
|
|
13
13
|
|
14
14
|
|
15
|
-
|
15
|
+
|
16
16
|
|
17
17
|
select sk2.区分,sk2.番号,max(sk2.年度) as 年度, sk2.学年
|
18
18
|
|
@@ -56,7 +56,7 @@
|
|
56
56
|
|
57
57
|
|
58
58
|
|
59
|
-
|
59
|
+
|
60
60
|
|
61
61
|
|
62
62
|
|
2
書式の改善
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,9 +12,7 @@
|
|
12
12
|
|
13
13
|
|
14
14
|
|
15
|
-
```
|
15
|
+
```ここに言語を入力
|
16
|
-
|
17
|
-
|
18
16
|
|
19
17
|
select sk2.区分,sk2.番号,max(sk2.年度) as 年度, sk2.学年
|
20
18
|
|
@@ -62,6 +60,12 @@
|
|
62
60
|
|
63
61
|
|
64
62
|
|
63
|
+
|
64
|
+
|
65
|
+
|
66
|
+
|
67
|
+
|
68
|
+
|
65
69
|
というsqlを実行すると結果が
|
66
70
|
|
67
71
|
|
1
ソースの表示を修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,7 +12,9 @@
|
|
12
12
|
|
13
13
|
|
14
14
|
|
15
|
-
```
|
15
|
+
```
|
16
|
+
|
17
|
+
|
16
18
|
|
17
19
|
select sk2.区分,sk2.番号,max(sk2.年度) as 年度, sk2.学年
|
18
20
|
|
@@ -54,6 +56,8 @@
|
|
54
56
|
|
55
57
|
Group by sk2.区分,sk2.番号,sk2.学年
|
56
58
|
|
59
|
+
|
60
|
+
|
57
61
|
```
|
58
62
|
|
59
63
|
|