回答編集履歴
3
修正
test
CHANGED
@@ -2,11 +2,11 @@
|
|
2
2
|
|
3
3
|
|
4
4
|
|
5
|
-
1. tel毎のtimeの最大値を求める
|
5
|
+
1. tel毎のtimeとidの最大値を求める
|
6
6
|
|
7
7
|
1. 最大値を元のテーブルと結合する
|
8
8
|
|
9
|
-
1. timeの最大値
|
9
|
+
1. timeの最大値、idの最大値、timeで降順にソートする
|
10
10
|
|
11
11
|
|
12
12
|
|
@@ -34,9 +34,11 @@
|
|
34
34
|
|
35
35
|
,MAX(time) AS maxtime
|
36
36
|
|
37
|
+
,MAX(id) AS maxid
|
38
|
+
|
37
39
|
FROM
|
38
40
|
|
39
|
-
tabname
|
41
|
+
tablename
|
40
42
|
|
41
43
|
GROUP BY
|
42
44
|
|
@@ -50,6 +52,8 @@
|
|
50
52
|
|
51
53
|
t2.maxtime DESC
|
52
54
|
|
55
|
+
,t2.maxid DESC
|
56
|
+
|
53
57
|
,t1.time DESC
|
54
58
|
|
55
59
|
;
|
2
修正
test
CHANGED
@@ -50,11 +50,7 @@
|
|
50
50
|
|
51
51
|
t2.maxtime DESC
|
52
52
|
|
53
|
-
,t1.id DESC
|
54
|
-
|
55
53
|
,t1.time DESC
|
56
|
-
|
57
|
-
|
58
54
|
|
59
55
|
;
|
60
56
|
|
1
修正
test
CHANGED
@@ -50,7 +50,11 @@
|
|
50
50
|
|
51
51
|
t2.maxtime DESC
|
52
52
|
|
53
|
+
,t1.id DESC
|
54
|
+
|
53
55
|
,t1.time DESC
|
56
|
+
|
57
|
+
|
54
58
|
|
55
59
|
;
|
56
60
|
|