回答編集履歴
1
誤植
test
CHANGED
@@ -6,7 +6,7 @@
|
|
6
6
|
, MAX(suji) OVER (PARTITION BY name) AS max_suji
|
7
7
|
FROM test
|
8
8
|
WHERE id = 11) as t
|
9
|
-
WHERE suji = maxs
|
9
|
+
WHERE suji = max_suji
|
10
10
|
```
|
11
11
|
|
12
12
|
参考までにサブクエリ部分の結果は
|