回答編集履歴
2
推敲
test
CHANGED
|
@@ -36,9 +36,9 @@
|
|
|
36
36
|
|
|
37
37
|
WHERE NOT EXISTS(
|
|
38
38
|
|
|
39
|
-
SELECT 1 FROM accounttable
|
|
39
|
+
SELECT 1 FROM accounttable
|
|
40
40
|
|
|
41
|
-
WHERE
|
|
41
|
+
WHERE 名前 = a.名前 AND ID > a.ID
|
|
42
42
|
|
|
43
43
|
)
|
|
44
44
|
|
1
訂正
test
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
|
|
17
17
|
)
|
|
18
18
|
|
|
19
|
-
)
|
|
19
|
+
) As 名前
|
|
20
20
|
|
|
21
21
|
, (select IP from accounttable
|
|
22
22
|
|
|
@@ -27,6 +27,8 @@
|
|
|
27
27
|
where 名前= a.名前 AND ID <= a.ID and IP is not null
|
|
28
28
|
|
|
29
29
|
)
|
|
30
|
+
|
|
31
|
+
) As IP
|
|
30
32
|
|
|
31
33
|
, 作成日
|
|
32
34
|
|