回答編集履歴

1

修正

2017/12/04 07:23

投稿

sazi
sazi

スコア25173

test CHANGED
@@ -6,7 +6,13 @@
6
6
 
7
7
  where id <(
8
8
 
9
+ select id from (
10
+
9
- select id from syslog where (row_number() over(order by id desc))=1000000
11
+ select id, row_number() over(order by id desc) as seq from syslog
12
+
13
+ ) as t
14
+
15
+ where seq=1000000
10
16
 
11
17
  )
12
18