[Solved] Given this SQL query for keyset pagination:SELECT * FROM products WHERE id > 100 ORDER BY id ASC LIMIT 5;What will be the result if the highest id in the table is 102? | Rest API

Rest API - Pagination Patterns

Given this SQL query for keyset pagination:

SELECT * FROM products WHERE id > 100 ORDER BY id ASC LIMIT 5;

What will be the result if the highest id in the table is 102?

AReturns 5 rows starting from id 100

BReturns no rows

CReturns 2 rows with id 101 and 102

DReturns all rows with id less than 100

Step-by-Step Solution

Solution:

Step 1: Analyze WHERE condition
WHERE id > 100 means rows with id 101 and above are selected.
Step 2: Check available rows and LIMIT
Only ids 101 and 102 exist above 100, so only 2 rows returned despite LIMIT 5.
Final Answer:
Returns 2 rows with id 101 and 102 -> Option C
Quick Check:
Rows returned = 2 [OK]

Quick Trick: LIMIT caps rows, but fewer rows may be returned [OK]

Common Mistakes:

MISTAKES

Master "Pagination Patterns" in Rest API

9 interactive learning modes - each teaches the same concept differently

More Rest API Quizzes

Given this SQL query for keyset pagination: