回答編集履歴
1
ちょうせい
test
CHANGED
|
@@ -1,6 +1,8 @@
|
|
|
1
|
+
nameごとにということでしたね・・・これでどうでしょう？
|
|
1
2
|
```SQL
|
|
2
3
|
select * from test as t1
|
|
3
4
|
where not exists(
|
|
4
|
-
select 1 from test where id=t1.id and suji>t1.suji)
|
|
5
|
+
select 1 from test where id=t1.id and suji>t1.suji and name=t1.name)
|
|
5
6
|
and id=11
|
|
6
7
|
```
|
|
8
|
+
|