我注意到分页记录集中有一些重复的行.
当我运行此查询时:
SELECT "students".*
FROM "students"
ORDER BY "students"."status" asc
LIMIT 3 OFFSET 0
我得到:
| id | name | status |
| 1 | foo | active |
| 12 | alice | active |
| 4 | bob | active |
下一个查询:
SELECT "students".*
FROM "students"
ORDER BY "students"."status" asc
LIMIT 3 OFFSET 3
我得到:
| id | name | status |
| 1 | foo | active |
| 6 | cindy | active |
| 2 | dylan | active |
为什么两个查询中都出现"foo"？