hard20 pts · first answer countssorting-and-searchingsql
Rows missing across paginated pages
An API returns orders with ORDER BY created_at LIMIT 20 OFFSET n. Some orders appear on two pages and others never appear, though no data changed. What is the most likely cause?
Discussion 0
Join free to post in the discussion.
Related questions
- Stopping SQL injectionBackend Developer
- Purpose of a database indexBackend Developer
- Rows returned by a LEFT JOINBackend Developer
- What a foreign key enforcesBackend Developer
- Atomicity in a money transferBackend Developer
- COUNT and AVG with NULLsBackend Developer
- Filtering grouped resultsBackend Developer
- Duplicate emails despite a checkBackend Developer