[Solved] You want to implement keyset pagination on a REST API that returns blog posts sorted by published date and id (both... Which SQL WHERE clause correctly handles pagination for multiple sorting keys? | Rest API

Rest API - Pagination Patterns

You want to implement keyset pagination on a REST API that returns blog posts sorted by published date and id (both ascending). Which SQL WHERE clause correctly handles pagination for multiple sorting keys?

AWHERE published_date > :last_date OR (published_date = :last_date AND id > :last_id)

BWHERE published_date >= :last_date AND id > :last_id

CWHERE (published_date, id) > (:last_date, :last_id)

DWHERE published_date > :last_date AND id > :last_id

Step-by-Step Solution

Solution:

Step 1: Understand multi-column keyset pagination
When sorting by multiple columns, use lexicographical comparison: first by date, then by id if dates equal.
Step 2: Identify correct WHERE clause
WHERE published_date > last_date OR (published_date = last_date AND id > last_id) correctly fetches next rows.
Final Answer:
WHERE published_date > :last_date OR (published_date = :last_date AND id > :last_id) -> Option A
Quick Check:
Multi-key pagination = C [OK]

Quick Trick: Use OR with tie-breaker for multi-column keyset [OK]

Common Mistakes:

Using tuple comparison unsupported by some DBs
Using AND instead of OR causing missed rows
Using >= causing duplicates

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

More Rest API Quizzes

Which SQL WHERE clause correctly handles pagination for multiple sorting keys?

Step 1: Understand multi-column keyset pagination

Step 2: Identify correct WHERE clause

Final Answer:

Quick Check:

Want More Practice?