Database Reference
In-Depth Information
SELECT * FROM "user_status_updates"
WHERE TOKEN("username") > TOKEN('alice')
LIMIT 1;
When we run this query, we'll find that no rows are returned. This tells us that we've
reached the last page.
This sort of two-step pagination might seem a bit arduous, but the process can be ex-
pressed concisely. We followed these steps until no more rows were returned:
1. Ask for the first rows in the table.
2. Ask for the next rows in the same partition as the last row that was returned.
Repeat until no more rows are returned for this partition.
3. Ask for rows in the next partition.
4. Go back to step 2.
