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