回答編集履歴
1
追記
test
CHANGED
|
@@ -1,15 +1,15 @@
|
|
|
1
1
|
```sql
|
|
2
2
|
|
|
3
|
-
SELECT AVG(`test`) FROM table_name LIMIT 0, 100;
|
|
3
|
+
SELECT AVG(`test`) FROM table_name ORDER BY `id` ASC LIMIT 0, 100;
|
|
4
4
|
|
|
5
|
-
SELECT AVG(`test`) FROM table_name LIMIT 100, 200;
|
|
5
|
+
SELECT AVG(`test`) FROM table_name ORDER BY `id` ASC LIMIT 100, 200;
|
|
6
6
|
|
|
7
|
-
SELECT AVG(`test`) FROM table_name LIMIT 200, 300;
|
|
7
|
+
SELECT AVG(`test`) FROM table_name ORDER BY `id` ASC LIMIT 200, 300;
|
|
8
8
|
|
|
9
|
-
SELECT AVG(`test`) FROM table_name LIMIT 300, 400;
|
|
9
|
+
SELECT AVG(`test`) FROM table_name ORDER BY `id` ASC LIMIT 300, 400;
|
|
10
10
|
|
|
11
11
|
・
|
|
12
12
|
|
|
13
|
-
SELECT AVG(`test`) FROM table_name LIMIT 900, 1000;
|
|
13
|
+
SELECT AVG(`test`) FROM table_name ORDER BY `id` ASC LIMIT 900, 1000;
|
|
14
14
|
|
|
15
15
|
```
|