[Solved] You have this SQL snippet for keyset pagination:SELECT * FROM users WHERE id >= :last_id ORDER BY id ASC LIMIT 10;What is the main problem with this query? | Rest API

Rest API - Pagination Patterns

You have this SQL snippet for keyset pagination:

SELECT * FROM users WHERE id >= :last_id ORDER BY id ASC LIMIT 10;

What is the main problem with this query?

AIt orders results in descending order

BIt may return the last record twice on consecutive pages

CIt does not limit the number of rows

DIt will skip the first record after last_id

Step-by-Step Solution

Solution:

Step 1: Analyze WHERE condition
Using >= means the row with id equal to last_id is included again.
Step 2: Understand pagination effect
This causes the last record of previous page to appear again on next page, duplicating results.
Final Answer:
It may return the last record twice on consecutive pages -> Option B
Quick Check:
Duplicate record risk = D [OK]

Quick Trick: Use > not >= to avoid duplicate last record [OK]

Common Mistakes:

MISTAKES

Master "Pagination Patterns" in Rest API

9 interactive learning modes - each teaches the same concept differently

More Rest API Quizzes

You have this SQL snippet for keyset pagination: