You have a REST API that uses keyset pagination with a composite cursor of (score DESC, id ASC). Which SQL WHERE clause correctly fetches the next page?

hard📝 Application Q9 of 15

Rest API - Pagination Patterns

AWHERE (score, id) < (:last_score, :last_id)

BWHERE score < :last_score OR (score = :last_score AND id > :last_id)

CWHERE score > :last_score OR (score = :last_score AND id < :last_id)

DWHERE score <= :last_score AND id >= :last_id

Step-by-Step Solution

Solution:

Step 1: Analyze sorting directions
Score is DESC, so next page means score less than last_score; id ASC breaks ties.
Step 2: Construct WHERE clause for composite cursor
WHERE score < last_score OR (score = last_score AND id > last_id) correctly fetches next rows.
Final Answer:
WHERE score < :last_score OR (score = :last_score AND id > :last_id) -> Option B
Quick Check:
Composite cursor with mixed order = A [OK]

Quick Trick: Invert comparison for DESC keys, use OR for tie-break [OK]

Common Mistakes:

Using > instead of < for DESC key
Mixing id comparison direction
Using AND instead of OR

Master "Pagination Patterns" in Rest API

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Rest API Quizzes

You have a REST API that uses keyset pagination with a composite cursor of (score DESC, id ASC). Which SQL WHERE clause correctly fetches the next page?

Step 1: Analyze sorting directions

Step 2: Construct WHERE clause for composite cursor

Final Answer:

Quick Check:

Want More Practice?