#001Off-by-One in LIMIT Clause
sql.easySQL
1-- Get page 2, 10 items per page
2SELECT id, name, email
3FROM users
4ORDER BY created_at DESC
5LIMIT 10 OFFSET 10;
6-- Expected: rows 11-20, but row 10 appears on both page 1 and page 2
no lines flagged
#001PracticeEasy8 min · 50 XP
Off-by-One in LIMIT Clause
A pagination query returns one extra row on every page, causing duplicate entries in the UI. Find the line causing the issue.
Flagged lines
No lines flagged yet
What's wrong?
Flag a line or write a note to submit.