回答編集履歴
2
推敲
answer
CHANGED
|
@@ -17,8 +17,8 @@
|
|
|
17
17
|
, 作成日
|
|
18
18
|
FROM accounttable AS a
|
|
19
19
|
WHERE NOT EXISTS(
|
|
20
|
-
SELECT 1 FROM accounttable
|
|
20
|
+
SELECT 1 FROM accounttable
|
|
21
|
-
WHERE
|
|
21
|
+
WHERE 名前 = a.名前 AND ID > a.ID
|
|
22
22
|
)
|
|
23
23
|
```
|
|
24
24
|
※手打ちで検証はしていませんので、悪しからず。
|
1
訂正
answer
CHANGED
|
@@ -7,12 +7,13 @@
|
|
|
7
7
|
select 名前, Max(ID) from accounttable
|
|
8
8
|
where 名前= a.名前 AND ID <= a.ID and 場所 is not null
|
|
9
9
|
)
|
|
10
|
-
)
|
|
10
|
+
) As 名前
|
|
11
11
|
, (select IP from accounttable
|
|
12
12
|
where (名前, ID) in (
|
|
13
13
|
select 名前, Max(ID) from accounttable
|
|
14
14
|
where 名前= a.名前 AND ID <= a.ID and IP is not null
|
|
15
15
|
)
|
|
16
|
+
) As IP
|
|
16
17
|
, 作成日
|
|
17
18
|
FROM accounttable AS a
|
|
18
19
|
WHERE NOT EXISTS(
|